LinkBack URL
About LinkBacksHi, I was just looking over my backup routine for cPanel and noticed that it isn't backing up Root's MySQL databases which on mine contains quite a bit of stuff. Is there any way to automate this or do I have to do this manually? Thanks.
Backing Up Root's MySQL Databases
Hi, I was just looking over my backup routine for cPanel and noticed that it isn't backing up Root's MySQL databases which on mine contains quite a bit of stuff. Is there any way to automate this or do I have to do this manually? Thanks.
Hi,
In this case you will have to check option WHM >> Configure Backup >> Backup SQL Databases >>"Per Account and Entire MySQL Directory" . Otherwise you will have to make script which will backup mysql database using command mysqldump mysql > "mysql`date | awk '{print "$3}'`.sql" and need to setup cron to execute this script.
If date on the server is May 7 then above command will create backup file as mysql17.sql
Regards,
VPS Hosting - Dedicated Server Hosting - Cheap Web Hosting - Linux Hosting - Reseller Hosting
Yes I have it setup to backup both but I don't see a folder for root in the cpbackup folder. Is there some specific place where it would be backing this up to that I should be looking in?
Reply With Quote