If you are hosting your website on your own webspace which supports PHP and Perl, you should check out if the free tool MySQLDumper
is something for you. It has some great advantages compared to phpMyAdmin:
- If your database is quite large, the backup file can be split up. This comes in very handy if the processing of a single large file would exceed the CPU limit (often 30 seconds for PHP scripts) or RAM limit of your hoster.
- You can create a Perl cronjob script which can be triggered by the cronjob tool of your hoster to create new backups automatically each day.
- You can additionally send the backup files to your e-mail account or upload it to another ftp server.
If you’re not understanding that stuff above, then this tool is most likely not something for you. The installation and configuration of the interesting parts (phpMyAdmin is sufficient for manual backups of small databases) was not that easy.