Firefox can't find the file at http://localhost/phpmyadmin/export.php

Question

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?

Need an answer to this old question... – Odys Mar 16 '13 at 20:23 — Odys, Mar 16 '13 at 20:23

score 7 · Accepted Answer · answered Mar 28 '11 at 13:17

7

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

answered Mar 28 '11 at 13:17

Ignacio Vazquez-Abrams

45,939
6
79
84

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" – Niraj Chauhan 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 – Niraj Chauhan 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

Firefox can't find the file at http://localhost/phpmyadmin/export.php

1 Answers1