MYSQL dump file using command prompt ?

First of all ,go to mysqldump utility folder eq. C:\wamp\bin\php\php5.3.0 using commad prompt and then type following code.

in this example wordpress database has username root without password.

login into command prompt if you are using XAMPP please follow following Step



step 1.  cd  c:\xampp\mysq\bin

Method 1.  mysql -u root -p -h localhost databasename < file.sql


file must save in your c:\xampp\mysql\bin


Method 2. >mysqldump --opt --user=root --password= wordpress > mydata.sql

Most Popular

ReactJs Top Hooks List

The difference between React vs AngularJs

crontab example in linux