Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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
2  
At the command line. Windows calls this "Command Prompt". –  Ignacio Vazquez-Abrams Mar 28 '11 at 13:41

Your Answer

 
discard

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.