Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a huge 1.6 GB MYSQL database on my wamp local server.

I want to shift this database to another computer, so in phpmyadmin, when I export the database and click GO for download the sql file, then it takes around 5-10 mins to load and at-last displays the error "Firefox can't find the file at http://localhost/phpmyadmin/export.php."

How can I have backup of the data?

share|improve this question
Need an answer to this old question... – Odys Mar 16 '13 at 20:23
up vote 7 down vote accepted

Use mysqldump to dump the contents of the database to disk instead.

share|improve this answer
when I enter this command mysqldump -u root -p --all-databases > d:\abc.sql in query window of phpmyadmin, I get following error "#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u root -p --all-databases > d:\abc.sql' at line 1" – ntechi Mar 28 '11 at 13:37
It's a command line program. – Ignacio Vazquez-Abrams Mar 28 '11 at 13:37
where to write this code, I am using windows 7 as OS – ntechi Mar 28 '11 at 13:39
At the command line. Windows calls this "Command Prompt". – Ignacio Vazquez-Abrams Mar 28 '11 at 13:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.