Sefket Posted February 6, 2012 Share Posted February 6, 2012 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. Link to comment Share on other sites More sharing options...
Michael Posted February 6, 2012 Share Posted February 6, 2012 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? Link to comment Share on other sites More sharing options...
Sefket Posted February 7, 2012 Author Share Posted February 7, 2012 Yes, I have. They use SSH and it doesn't get corrupted for them. The database is 2gb according to them. Link to comment Share on other sites More sharing options...
nylyon Posted February 7, 2012 Share Posted February 7, 2012 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? Link to comment Share on other sites More sharing options...
Sefket Posted February 7, 2012 Author Share Posted February 7, 2012 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 Link to comment Share on other sites More sharing options...
Cloaked Posted February 7, 2012 Share Posted February 7, 2012 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. Link to comment Share on other sites More sharing options...
Hunting insects... Posted February 7, 2012 Share Posted February 7, 2012 phpMyAdmin is useless for backup of all but the tiniest databases. Try something like mysqldumper. Link to comment Share on other sites More sharing options...
Grumpy Posted February 8, 2012 Share Posted February 8, 2012 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.