MySQLDumper for automatic backups of your database

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

MySQLDumper for automatic backups of your database

Post by Novil » 30 Aug 2009, 23:04

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.
Sandra and Woo | Sandra und Woo auf Deutsch
Gaia | Gaia auf Deutsch

"Don't be someone who they forget!"
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 » 31 Aug 2009, 01:13

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
President and First Tigress
Posts: 2212
Joined: 14 Oct 2008, 01:11
Contact:

Re: MySQLDumper for automatic backups of your database

Post by powree » 31 Aug 2009, 10:44

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 » 31 Aug 2009, 14:28

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