Skip to main content

MYSQL dump file using command prompt ?

By October 31, 2011My SQL
First of all ,go to mysqldump utility folder eq. C:wampbinphpphp5.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:xamppmysqbin

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

file must save in your c:xamppmysqlbin

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

Leave a Reply

13 + = 21

Open chat
💬 Need help?
Hello 👋
We are expert at building website and digital properties. Do you have an idea that you want to bring to life. Let us know and we will build it for you.