Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 6, 201212 yr 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.
February 6, 201212 yr 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?
February 7, 201212 yr Author Yes, I have. They use SSH and it doesn't get corrupted for them. The database is 2gb according to them.
February 7, 201212 yr 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?
February 7, 201212 yr Author 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
February 7, 201212 yr 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.
February 7, 201212 yr phpMyAdmin is useless for backup of all but the tiniest databases. Try something like mysqldumper.
February 8, 201212 yr 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.
Archived
This topic is now archived and is closed to further replies.