search



  

Latest 5

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
PHP Filemtime() Function - Last Updated
Posted: 2017-10-14 14:43:44

Top 5

Norwegian Kennel Club Database
Posted: 2015-10-22 10:36:06 (2018 Reads)
LOSH (Belgium) Scans Available
Posted: 2017-04-29 19:47:07 (1708 Reads)
AKC 1890
Posted: 2015-10-16 15:29:12 (1680 Reads)
ENCI - Italian Studbook
Posted: 2015-10-26 09:54:35 (1629 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.25 seconds
307,800 unique visits