Exporting database from PhpMyAdmin

[Sefket]

Is there a way to export a database from PhpMyAdmin without it getting corrupted? I don't want to use SSH yet as I'm not experienced yet.

[Michael]

If your database is getting corrupted every time you export it from phpMyAdmin, then it sounds like something is wrong with your installation of phpMyAdmin. Have you discussed the issue with your host?

[Sefket]

Yes, I have. They use SSH and it doesn't get corrupted for them. The database is 2gb according to them.

[nylyon]

Assuming the extract is getting corrupted and not the database, are you exporting as a .gz or .zip type file? Try no compression to see if that works for you. What exactly are you seeing for corruption?

[Sefket]

I wasn't compressing it at all.

It said ERROR 1064 (42000) at line 10178201: 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 '
Fatal error: Maximum execution time of 300 seconds exceeded in
Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/export/sql.php on line 1053

[Cloaked]

Your database is too big for phpMyAdmin to handle. You need to up the max execution time in php.ini or dump the data in chunks.

[Hunting insects...]

phpMyAdmin is useless for backup of all but the tiniest databases. Try something like mysqldumper.

[Grumpy]

Adding to above post, when you want to restore the big dumps. Try bigdump. xD
http://www.ozerov.de/bigdump/

Though... I wouldn't say "tiniest"... but anything over few hundred megs seem to be non-optimal as it tries to do it in 1 go.