To get a mysql dump of a database in wamp, first we need to set our mysql path using set path command. The example is given below.
Replace c:\wamp\bin\mysql\mysql5.1.36\bin with your mysql bin directory path.
Then use the below command to export our database.
YourUserName will be our mysql username. And YourDatabaseName will be our DataBase name. Then command prompt will ask for the mysql password. Your should enter your mysql password to get your sql dump of your database.
Have any doubt, feel free to comment here!
set path=c:\wamp\bin\mysql\mysql5.1.36\binReplace c:\wamp\bin\mysql\mysql5.1.36\bin with your mysql bin directory path.
Then use the below command to export our database.
mysqldump -u YourUserName -p YourDatabaseName > sqlDumpFileName.sqlYourUserName will be our mysql username. And YourDatabaseName will be our DataBase name. Then command prompt will ask for the mysql password. Your should enter your mysql password to get your sql dump of your database.
Have any doubt, feel free to comment here!
To get a mysql dump of a database in wamp, first we need to set our mysql path using set path command. The example is given below.
Replace c:\wamp\bin\mysql\mysql5.1.36\bin with your mysql bin directory path.
Then use the below command to export our database.
YourUserName will be our mysql username. And YourDatabaseName will be our DataBase name. Then command prompt will ask for the mysql password. Your should enter your mysql password to get your sql dump of your database.
Have any doubt, feel free to comment here!
set path=c:\wamp\bin\mysql\mysql5.1.36\binReplace c:\wamp\bin\mysql\mysql5.1.36\bin with your mysql bin directory path.
Then use the below command to export our database.
mysqldump -u YourUserName -p YourDatabaseName > sqlDumpFileName.sqlYourUserName will be our mysql username. And YourDatabaseName will be our DataBase name. Then command prompt will ask for the mysql password. Your should enter your mysql password to get your sql dump of your database.
Have any doubt, feel free to comment here!
by Jillur Rahman
Jillur Rahman is a Web designers. He enjoys to make blogger templates. He always try to make modern and 3D looking Templates. You can by his templates from Themeforest.
Follow him @ Twitter | Facebook | Google Plus
No Comment