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

Plesk 12.x / Linux :: Scheduled Tasks Not Working?

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

Plesk 12.x / Linux :: Scheduled Tasks Not Accessible

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

Plesk 12.x / Linux :: Scheduled Tasks Always Fail?

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

Plesk 12.x / Linux :: Scheduled Tasks For User Root

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

Plesk 11.x / Linux :: CRON Is Not Executed (scheduled Tasks)

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

Plesk 11.x / Linux :: Scheduled Tasks - Correct Permissions

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

Plesk 12.x / Linux :: Domain Scheduled Tasks (Client Area)

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

Plesk 12.x / Windows :: Scheduled Tasks Not Working After Moving To New Server

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

Plesk 12.x / Linux :: How To Create Two Backup Tasks

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

Plesk 12.x / Linux :: Backup Manager Automating Tasks

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

Plesk 11.x / Linux :: Failed To Execute Backup Of Mysql Database

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

Plesk 11.x / Linux :: Autoupdate Fails ERROR While Trying To Backup MySQL Database

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

Plesk 11.x / Linux :: CentOS Backup Commands For Website Files And MySQL Database

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

Plesk 12.x / Linux :: Scheduled Backup Not Working?

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

Plesk 12.x / Linux :: Error During Scheduled Backup Process

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

Plesk 12.x / Linux :: CLI - Scheduled Backup From Command Line

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

Plesk 11.x / Linux :: Upgrade Scheduled Backup Not Working?

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

Plesk 12.x / Linux :: Scheduled Backup Don't Load (cron Job)

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

Plesk 12.x / Linux :: Scheduled Backup Stopped Working

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

Plesk 12.x / Linux :: Global Scheduled Backup Task Not Working

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

Plesk 12.x / Linux :: Scheduled Backup Hangs At 100% - Never Finishing Completely

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

Plesk 12.x / Linux :: Required Storage For Multi-volume Scheduled FTP Backup

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

Scheduled Tasks For .aspx Files

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

Is It Possible To Create A Cron To Backup Mysql Data Daily

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

Plesk 11.x / Windows :: Importing MySQL Backup - Unable To Restore Database

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

Plesk 11.x / Windows :: How To Run A Task After Scheduled Backup

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

Daily Backup From Linux To Windows

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

Plesk 12.x / Windows :: Local Scheduled Backup Error

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







Copyrights 2005-15 www.BigResource.com, All rights reserved