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.
set path=c:\wamp\bin\mysql\mysql5.1.36\bin
Replace 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.sql
YourUserName will be our mysql username. And YourDatabaseName will be our DataBase name....
Thursday, 26 February 2015
Subscribe to:
Posts (Atom)