Monday, September 1, 2008

MySQL Database Dump from shell....

Hello Friends,
This is how we can take a database dump from command prompt.

1. Suppose you want to dump the entire database u can fire following command from cmd prompt...
"test_dump" will be your database name...
Your_location_where_you_want_to_save:\> mysqldump -u root -p test_dump > filename.sql


2. Suppose there are n numbers of table and we want to take a back of only 2 table let say table_abc, table_xyz from the "test_dump" database, so you can fire the below mention query...

Your_location_where_you_want_to_save:\> mysqldump --add-drop-table -u root -p test_dump table_abc table_xyz > filename.sql

Note: -
1. The filename can be anything.
2. Your_location_where_you_want_to_save = can be let say c drive c:\>

No comments: