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.
mysqldump -uusername -ppassword databasename | gzip -9 >/httpdocs/mydatabase.sql.gz
or
mysqldump -uusername -ppassword databasename >/httpdocs/mydatabase.sql.gz
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" ?
View 2 Replies
ADVERTISEMENT
Feb 4, 2015
I have created a scheduled task as per my application guide as in the attached file. When i recieve the email it says the following:
: /var/www/vhosts/testdomain.co.uk/clients/admin/cron.php: No such file or directory
i have also tried appending:
php -q
wget -O (using the http to the location to cron.php)
Nothing seems to work.
I have transfered from cpanel and this is my first scheduled task and not getting anywhere with very little information on how to do this.
Im running:
Plesk 12
Linux
View 1 Replies
View Related
May 28, 2015
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
View 1 Replies
View Related
Feb 17, 2015
Whenever a user in my Cloudlinux powered Plesk Panel 12 tries to use the scheduled tasks, this is the error that is emailed to them...
excel: couldn't exec `/usr/local/psa/bin/chrootsh'
excel: No such file or directory
Does not matter what the task is, same error every time.
Even something as simple as wget [URL] .....
View 10 Replies
View Related
Jun 27, 2014
Looking at a server with Plesk 12 installed there is no root user shown in tools & settings / scheduled tasks.
Login as root and crontab -l shows root has some tasks.
On a similar server with Plesk 11.5 installed can see root user shown in tools & settings / scheduled tasks.
View 1 Replies
View Related
Oct 23, 2014
plesk 11.5
centos 6
We set a couple of task with domain user but the cron is not executed.
We tried 2 kind of task to run every minute
/usr/bin/php /var/www/vhosts/domain.com/httpdocs/cron.php
and
mail -s "Hello" admin@domain.com
1) Why scheduled task are not executed?
2) Where the tasks are written in filesystem from plesk ? /etc/....?
View 3 Replies
View Related
Jun 2, 2014
I have the following command to execute every 5 minutes this PHP file which is working correctly:
/usr/bin/wget -qq -O /dev/null http://url.com/script.php
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.
Plesk version: 11.5.30 Update #44
View 2 Replies
View Related
Jul 22, 2014
We have a VPS with Centos 5 and Plesk 12.0.18.
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.
The task is a simple WGET command.
View 3 Replies
View Related
Jul 7, 2014
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?
Currently Installed: v. 12.0.18
View 1 Replies
View Related
Nov 6, 2014
I see I can only create a single backup task in plesk, server self repository or ftp repository.
My idea is duplicate backups inside and outside of my vps, I mean, I want to create a backup task in my vps and in my own ftp server.
It is possible?
View 3 Replies
View Related
Mar 1, 2015
I have setup Backup Manager to backup Files and Configurations every week for every subscription. This worked really good however we are now considering changing this to daily basis.
As the free space on server will decrease. I was wondering i there is any way with cronjobs how to remove the backup older than 24 weeks. How to make such an cronjob script?
If possible i also would like to know where the Backup Manager physically stores its backups?
View 5 Replies
View Related
Feb 19, 2015
My OS is CentOS 5.8.
Plesk is 11.0.9.
Having problems with failed daily domain backups. All databases that have been created by Plesk cannot be backed up, thus backup fails with the following message:
<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/2015-02-19-044701.875/migration.result">
[Code]...
View 4 Replies
View Related
Jun 16, 2014
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
View 2 Replies
View Related
May 27, 2014
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies
View Related
Nov 5, 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.
View 3 Replies
View Related
Jun 18, 2014
Sometimes I get this error:
Domain: mydomain.com
Plesk entry point: https://myserver.local:8443/
Following error is occurred during scheduled backup process:
[Errno 17] File exists: '/usr/local/psa/PMM/logs/backup-2014-06-18-23-30-05-556'
but in the backup.log and in the pmmcli.log I don't found any error.
What does it mean?
View 8 Replies
View Related
Apr 9, 2015
I'm looking to set up a schedulled backup from command line.
I haven't found the correct command, could you tell me if it's possible and how ?
Additional question: I'm looking too, to set for the server the max number backup file to save, do you know how to do it from cli ?
View 8 Replies
View Related
Jul 6, 2012
I have the same problem again with plesk 11 [URL]
workaround
1) rpm -q --scripts psa-backup-manager | sed 1d | sh
2) /etc/init.d/crond restart
my error message with CentOS 5.8, Plesk 11.0.9 MU#4
sh: line 2315: syntax error near unexpected token `('
sh: line 2315: `preuninstall scriptlet (using /bin/sh):'
/etc/cron.d/plesk-backup-manager is created
why do not work after you upgrade the backup cronjobs?
View 19 Replies
View Related
Jul 14, 2015
Plesk Backup work when we make instant backup but not with scheduled backup.
There is nothing in the log files (pmmcli.log & migration.log).
How can we correct?
Plesk 12 / Centos
View 1 Replies
View Related
Feb 12, 2015
on one of our Plesk-Servers (Plesk 12.0.18 Update 34 on Debian 7.6) the scheduled backup stopped working. Scheduled Backup is active in Backup-Manager, but it's not executed.
View 2 Replies
View Related
Dec 19, 2014
I'm running: 12.0.18 Update #29
I'm having troubles getting the global scheduled backup task to work at Home > Tools & Settings >Backup Manager > Server Repository.
At a subscription the scheduled backup works how it should.
Home > Subscriptions > example.com > Websites & Domains > Server Repository
The problem is as follows: When I set the scheduled task at a specific time example 00:00 it does not run at all. But when I just do "Create a backup" it does work...
I've done [URL] .... and everything in here is configured how it should be.
This is my configuration for scheduled task:
Cronjob is placed in : /etc/cron.d/plesk-backup-manager-task
Also did run: rpm -q --scripts psa-backup-manager | sed 1d | sh
This problem is only in the global backup configuration.
View 3 Replies
View Related
Jan 24, 2015
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)
[2015-01-20 21:33:53.108|18485] INFO: ENV[LANG]=en_US.UTF-8
[2015-01-20 21:33:53.108|18485] INFO: Executing utility: /bin/sh -c -e /bin/tar --create --file /usr/local/psa/PMM/tmp/backupznMOWN/daily__1501202046.tar --directory /tmp/repo_transport_tmp_Jalkfn/ --dereference --files-from /tmp/repo_transport_tmp_UTCFhv
[2015-01-20 21:41:12.528|18485] INFO: The utility executed with the return code 0
[Code] ....
View 19 Replies
View Related
Apr 8, 2015
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
View 5 Replies
View Related
Oct 26, 2009
How to execute specific .aspx file in scheduled task in win 2003 server or how to Create Scheduled Tasks for .aspx Files?
View 14 Replies
View Related
May 15, 2009
Is there any way to create a cron to backup mysql data daily ( or weekly )? I mean an "auto script" to run this command daily
mysqldump -u usernam -p password dataname > file.sql
View 11 Replies
View Related
Mar 20, 2014
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
View 7 Replies
View Related
Oct 29, 2014
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.
View 4 Replies
View Related
Apr 5, 2007
I want to know how can backup my linux server data's to windows server? due high number of files and daily updates i cant use FTP
View 3 Replies
View Related
May 22, 2015
I have recently upgraded Plesk Panel from 11.0.5 windows to 12.0.18 MU#46 windows.
As checked that local plesk backup via GUI throwing error and is not working. On checking the event viewer I found below event during backup run.
Log Name: Plesk
Source: scheduled_backup.exe
Date: 5/23/2015 6:52:06 AM
Event ID: 1
Task Category: None
Level: Warning
[Code] ....
View 1 Replies
View Related