Thursday, 26 February 2015

How to get sql dump using command prompt in WAMP 0

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....