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