Backup database doesnt work

Private Joined: Jul 06, 2008 Posts: 48

Hello,

I wonder when I click on Backup in admin area and why I always download "admin.php" instead of my db sql ?How can I fix this error ?

Thanks

Site Admin Joined: Aug 17, 2003 Posts: 12397

The Backup DB function isn't designed to handle large databases. Use phpMyAdmin to export your database, it handles them much better

Captain Joined: Sep 13, 2003 Posts: 314

For really big databases one can get timed out in phpMyAdmin, so in this situation I use MySQLDumper, which can both backup and restore.
http://www.mysqldumper.de/en/

Private Joined: Jul 06, 2008 Posts: 48

I think I should split my large db.

Thanks Slackervaara for the link

Captain Joined: Sep 13, 2003 Posts: 314

My database is 140 MB and I can make a complete backup of it with MySQLDumper. Interestingly the uncompressed backupfile is over 300 MB, which is caused by the backup is made with Complete inserts, which makes restores more accurate. During backup the backupfile is compressed, so it is actually only 40 MB.