Plesk 11.x / Linux :: How To Do MySQL Database Daily Backup Via Scheduled Tasks
Feb 12, 2015
I'm new to Parallels Panel. I use version 11.0.9. I want to backup mysql database daily. First of all, what is the best way for daily database backup in plesk. I'm trying to do this in Scheduled Tasks and I use mysqldump command although I'm not sure.
I chose the time and day first and then I switched on the task. I typed the following command to Command line.
This created only a blank file. When I use this without gzip, nothing changes.
1- Is mysqldump right command for database backup?
2- Should I define full path for mysqldump, gzip and database? If so, how can I find out the full path of mysqldump, gzip and my database? Because I can't see their locations in panel.
3- I can't see any error message. There is not any log file in httpdocs folder. Where does the log file exist?
4- It is weird but should the username be "database user" or should I write "root" ?
after creating a new cron job, when i try to open Scheduled Tasks i get this error :Internal error: DateTime::__construct(): Failed to parse time string (2015-05-28 0.12:0:37) at position 17 ): Unexpected character
Message DateTime::__construct(): Failed to parse time string (2015-05-28 0.12:0:37) at position 17 ): Unexpected character File Helper.php Line 143 Type Exception
How can I make it so only the system (scheduled task or the server itself) can access to the file to execute it. I tried placing CHMOD 700 to the PHP file but everyone is still able to access to it and executive it.
The CRON service is running and works correctly, the Scheduled tasks on the administration Plesk Panel (tools & Setting / Scheduled tasks / root user) works ok, but when a customer sets a new scheduled task from her domain panel, don't works.
I've just migrated server to server but I didn't use the migration manager, I simply backed up each domain's content and restored those backups on the new server.
The issue I have run into is the scheduled tasks at the admin level (Tools & Settings > Scheduled Tasks) work but any schedule task under a domain do not. The scheduled tasks under the domains show as inactive (no green tick) and when I click to enable them, I get the following message
"Information: The scheduled task Google Product Feed Daily Scheduled Task was switched on."
If I then look at the page, even though the above message says it is, the scheduled task is still not enabled. Going into the scheduled task and switching it on there results in the same message, but it doesn't switch on.
How to rebuild all of the scheduled tasks within Plesk?
why but autoupdate fails. It doesn't give a reason why it cant backup.
For line of log :
START pp11.5.30-bootstrapper-11.5.30-cos5.build115131216.11 installing AT Thu Mar 27 07:43:37 CET 2014
Last lines of log :
===> Upgrading database
Trying to start service mysqld... mysqld (pid 24610) is running... done Trying to establish test connection... connected done Trying to find psa database... version is 011005030 Version is OK, no need to create psa database. Trying to backup MySQL database... ERROR while trying to backup MySQL database Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
Trying to start psa...
**** Product prep-install for BASE failed.
***** problem report ***** ERROR while trying to backup MySQL database Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again STOP Bootstrapper 11.5.30 prep-install for BASE AT Tue Jun 17 04:04:48 CEST 2014
I am running Plesk 12 on CentOS 7 64bit. I have set up the server backup instead of the website backup as I assume that will backup all server settings, as well as the website? I am running Plesk Web Admin Edition.
I have the backup set to run and dump into Personal FTP, but it does not run. If I run the backup manually, everything works great, but the scheduled backups don't work.
I have an issue with my daily backup. I configured to have a daily backup on an external FTP server. Everything looks to work correctly but in the panel I see that the task is a 100% forever. Never finishing completely.. So the next day, the task is not starting.. I have to remove manually the task in backup manager screen.
here is the last lines of the log file (in /var/log/plesk/PMM/backup-2015-01-20-20-46-02-824)
My Centos server running Plesk12 is running scheduled backups every sunday 3AM.
The backup is configured so that it's created as a multivolume backup with a volume size of 2047MB.
The backup is placed on my Personal FTP repo (another plesk12 server mounted with big storage).
The backup content is configured to backup server config and content (all).
The problem I have is when the backup is running I can see that it creates the volumes and stores it locally. After it send all the volumes the the external FTP repo it will delete the local (tmp) data. See my attached screenshot for storage health during backup.
Is this behaviour normal? This way we can never run a backup to an external FTP repo when our server passed 50% storage. Is it not normal to:
- Create a volume - Send it to FTP repo - Delete volume locally - Repeat until done
Is there a way to run an additional task after the scheduled backup has completed?I want to copy the backup off-site. I can't use FTP, otherwise I'd use the built-in 'Personal FTP Repository' feature. (See Rsync, Amazon S3, Rackspace cloud files, etc)
I could just create a new scheduled task, but the backup takes an unpredictable amount of time, and the tasks need to run sequentially. Also, the 2nd task should only run if the backup succeeds.
I could disable the backups in the control panel and create a new scheduled task that does both the backup and the additional task. But then the functionality of the control panel's Backup Manager page is lost.