search



  

Latest 5

UMaine Studbook Collection
Posted: 2018-10-14 06:34:38
Club Francais Korthals N79 1975
Posted: 2018-01-27 04:36:49
Invisible Google Captcha
Posted: 2017-11-10 12:51:42
Font Awesome
Posted: 2017-10-25 01:25:14

Top 5

Norwegian Kennel Club Database
Posted: 2015-10-22 10:36:06 (2130 Reads)
AKC 1890
Posted: 2015-10-16 15:29:12 (1822 Reads)
AKC 1895
Posted: 2015-10-22 11:38:43 (1803 Reads)
LOSH (Belgium) Scans Available
Posted: 2017-04-29 19:47:07 (1794 Reads)

Join our Newsletter

to get informed about new blog entries!
We care about your privacy - we do not send our Newsletters to all registered users, only if you subscribe HERE!
* indicates required
Choose your Category/Categories

Facebook


Ask for becoming a member of the closed group: Dog Pedigree Databases/Research

Backup your database

I hope that you all backup your databases regularly, and with regularly I mean at least once a day. Those data are too valuable to get lost. 
I have been using MySQLDumper for years, a PHP and Perl based tool for backing up MySQL databases and I really loved it. Now with PHP 7 it stopped working properly and the developer decided to stop the work on that project.
So not wanting to make a dump every day manually from the phpAdmin surface, I wrote a php file which runs as a cronjob on my server.
Feel free to use and/or modify the code (you must change the bold data to your specifications)!

 


For those with perl available on their computer please email me if you are interested in a pure perl script to dump a mySQL database!


The Pedigree Cloud: php SQL codesnippets 

Comments

No Comments have been Posted.

Post Comment

Please Login to Post a Comment.

Ratings

Rating is available to Members only.

Please login or register to vote.
No Ratings have been Posted.
Render time: 0.29 seconds
333,973 unique visits