MySQLDumper for automatic backups of your database

General discussions about comics, current events, media, politics, etc.
Post Reply
User avatar
Novil
Supreme Ruler and Dictator-for-Life
Posts: 10638
Joined: 08 Sep 2008, 15:04
Location: Waiblingen, Germany
Contact:

MySQLDumper for automatic backups of your database

Post by Novil »

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.
User avatar
Rabid_Fox
Secretary
Posts: 56
Joined: 17 Jul 2009, 10:47

Re: MySQLDumper for automatic backups of your database

Post by Rabid_Fox »

I don't understand it but, in fairness, I'm fundamentally useless. Except that I make a darned tasty curry.
Oh my.
User avatar
powree
Secretary General
Posts: 2562
Joined: 14 Oct 2008, 01:11

Re: MySQLDumper for automatic backups of your database

Post by powree »

All I understand is how to pull a straight line, lol...

I'll pass the information to others :D They might understand its uses.
User avatar
Rabid_Fox
Secretary
Posts: 56
Joined: 17 Jul 2009, 10:47

Re: MySQLDumper for automatic backups of your database

Post by Rabid_Fox »

Hooray for us not in the know!
Oh my.
Post Reply