Cannot save the dump of a database


#1

I’m trying to save my DB from the “export” page in sqlmyadmin, it waits for some time and then stops without doing anything.

It works if I select “none” for compression but it does nothing if I choose “zipped” or “gzipped”.

Not even an error message.


#2

Are you sure you checked ‘save as file’? It’s easy to miss that checkbox. I forgot once and it did what you described. The old version of phpMyAdmin would have dumped the data to the screen, I believe - this version just went away for a while …


#3

use mysqldump (from the command line).

mysqldump -uUSERNAME -pPASSWORD -hDBHOSTNAME DBNAME > FILENAME.SQL

to load again use
mysql -uUSERNAME -pPASSWORD -hDBHOSTNAME DBNAME < FILENAME.SQL

-Jason

I40.com - Home Page
MP3Mystic - Personal Streaming Music server.
(No longer hosted with Dreamhost)