cancel
Showing results for 
Search instead for 
Did you mean: 

[PAYH] MySQL Database backup

SoulBriski
Grafter
Posts: 179
Registered: ‎15-06-2007

[PAYH] MySQL Database backup

Since we can't use any ODBC or the MySQL Administrator to connect to our databases on the PAYH platform, How do we best backup our databases?
Is our only option to use the Export feature in the DB WebAdmin through Plesk?
Can we automate this?
Can we schedule it?
2 REPLIES 2
Peter_Vaughan
Community Veteran
Posts: 14,469
Registered: ‎30-07-2007

Re: [PAYH] MySQL Database backup

I have used a PHP based backup solution in the past called phpMyBackupPro. If you can create cron jobs then this can be automated by running a supplied php script.
It can create backups to local files and also email it to you as an attachment. It also has a FTP mode to ftp a backup file to somewhere else. You can also include local non-mysql files to backup as well.
SoulBriski
Grafter
Posts: 179
Registered: ‎15-06-2007

Re: [PAYH] MySQL Database backup

Thanks Peter
Very useful bit of kit this.
I've installed it, carried out my first backup, everything seems good.
The only thing I haven't mastered is crontab. It's available in the Plesk CP but I've never used it before and don't know what the command line would be.
The phpMyBackupPro has it's own scheduler which you set up by inserting the script into one of your own pages and then telling it to run the script hourly, daily, weekly etc or even on every hit of that page. That may be something new since you last used it?
Thanks again for your very helpful tip.