Wednesday, 2 May 2012

MYSQL: Create database dump from command line (WINDOWS)

Hi Readers,

Really in MYSQL/WINDOW, I have many obstacles and searches internet more than 7-8 hour for create a dump file of my database with compatible for all mysql db engines. And finally I fry some thing below: -

Steps-1 Go to your MYSQL installed directory inside bin
              C:\Program Files\MySQL\MySQL Server 5.0\bin
Steps-2 Use mysqldump command for create the backup.
              mysqldump -uyour_username -pyour_password your_databasename > D:\mybackup.sql

Steps-3 Press Enter

Now check your D drive and find the mybackup.sql file.

Hope it will help you.
Ping me always.