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]...
I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
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'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" ?
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 RelatedSince we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.
If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.
I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.
Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.
But how I can fix this problem for all Windows-Servers.
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...
I'm trying to recover a 8 Gb backup via Ftp as you can see in the attach 2.png.
Ftp begins recovering correctly and after 1,5 or 2 Gb aprox, PLEX shows a message like attach 1.png.
I translate the message: "Operation is taking too long..."
After error message, we can see Ftp working till the end but after that there is nothing restored.
I keep getting this warning on one of my domains.
I was running on a Ubuntu 10.04 LTS VPS and had this error too, then yesterday imported the domain from the old VPS to our new Plesk Server (Ubuntu 12.04.3 LTS) and I still get this error on this one domain.
This is the error in question...
Warning:hosting "mydomain.tld"
Failed to pack files Backup_mydomain.tld_user-data_1311120042 in /var/lib/psa/dumps/domains/mydomain.tld [ 49562925056 bytes free of 53687091200 bytes total on mount point 0]
Warning:hosting "mydomain.tld"
For security reason backup is performed on behalf of subscription system user. System user has no read access to backup file.Click to expand...
All domains were offline this morning. Plesk showed the following error message. It seems we are beta testing the software. I am on Suse 13.1, clean install.
Unable to rotate dump: The dump rotation is failed with code '1' at /usr/local/psa/admin/bin/plesk_agent_manager line 1041.
Warning: domain "abc.com"
The domain 'abc.com' may be inaccessible after backup. Please, resume it manually!
Warning: domain "abc.com"
Cannot resume domain 'abc.com' (ErrorCode: 255, STDOUT [Error:].
I try to backup server and become error
Code:
# plesk bin pleskbackup server
UNIVERSAL->import is deprecated and will be removed in a future perl at (eval 13) line 3.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run.pm line 1060.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run/IO.pm line 78.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run/Timer.pm line 161.
Runtime error: Could not run make dump with pmmcli[Illegal seek]
Code:
# /usr/local/psa/admin/sbin/pmmcli
Traceback (most recent call last):
File "/usr/local/psa/admin/sbin/pmmcli", line 5, in <module>
import pmmcli
File "/usr/local/psa/admin/share/pmmcli/pmmcli.py", line 21, in <module>
import pmmcli_session
File "/usr/local/psa/admin/share/pmmcli/pmmcli_session.py", line 15, in <module>
import pmm_migration_handler
File "/usr/local/psa/admin/share/pmmcli/pmm_migration_handler.py", line 16, in <module>
import migration_handler
ImportError: Bad magic number in /usr/local/psa/admin/share/migration-handler/migration_handler.pyc
Since Microupdate 11.0.9 #52/#53 I get the following error from my scheduled backup:
<description>Failed to pack files back__domainname_mn_1306110314 in /var/lib/psa/dumps/xy/clients/xy/domains/domainname [ 945838637056 bytes free of 980876906496 bytes total on mount point 0]</description>
Some related problems have already been discussed here in the forum (e.g.: [URL] .... or this one: [URL] ...., but it all did not quite match with my problem.
Any way to backup every SQL Databases at once ?
At the moment i need to configure each subscription on my backup program to backup each sql database.
there is any way to set a login that back's up all the databases?
And for the ftp files?
a Backup from Plesk 11.0.9 last MU installed to Plesk 12.0.18 last MU installed brings a lot of:
Database:
<message code="FailedDatabaseUserDeployment" severity="warning" id="160ffa07-4a78-400b-88f9-8a4292b78c30">
<description>Failed deployment of database user phpbb of database usr_web2_3</description>
<message code="ExecCmd::ExFailed" severity="warning" id="f5e9a089-a046-4937-8fe0-bbaee9e61b7b">
[Code]....
I have a new installation of Plesk 12.0.18 on CentOS 6.6.This is the text from the server information page in Plesk:
Parallels Plesk v12.0.18_build1200140606.15 os_CentOS 6
CentOS 6.6 (Final)
I am not able to take backups of the content of the server. This is the error I get:
Error:
Runtime error: The check dump failed with code '1'. The dump can contain invalid data! at /usr/local/psa/admin/bin/plesk_agent_manager line 1022.
Error:
The dump have been invalidated by check-dump operation
I'm trying to upload backup ms sql server file. But the Control panel tells me error: "Error: copy_file failed: filemng cp failed:"
View 4 Replies View RelatedI'm not been able to start plesk although web and mail services are running.I'm getting the error unable to execute php_handlers_control.I've patched and updated plesk with command line and bootstrap repair and I'm getting this errors:
==> Checking for: mail_responder_restore... fail
/usr/lib64/plesk-9.0/mail_restore: line 820: 17063 Illegal instruction /usr/local/psa//admin/sbin/mailmng-service --restart-service
Errors occured in mail restore procedure
Some utilities have exited with errors:
/usr/lib64/plesk-9.0/mail_auth_dump
/usr/lib64/plesk-9.0/mail_responder_restore
I get Illegal Instruction When I run :
# /usr/local/psa/admin/sbin/mailmng-service --restart-service
Illegal instruction
Also I switched from postfix to qmail and back using the command line with no luck.
/usr/local/psa/admin/bin/mailmng --features
runs without problems.....
/usr/local/psa/admin/logs/panel.log:
[06-Apr-2015 12:47:25 America/New_York] PleskUtilException: '/usr/local/psa/admin/bin/php_handlers_control' '--list-json' failed with code 4.
[code]....
I have this error when i put import to mysql database
Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<script></script><p>ERROR: Maximum execution time of 300 seconds exceeded (Util.' at line 244
I have in domain > doemainname >
max_execution_time
Standaard
Geef een aangepaste waarde op 0
and insert in
usr/local/psa/admin/htdocs/domains/databases/phpmyadmin in the file config.sample.inc.php following command
$cfg['ExecTimeLimit'] = 70000;
but it will not work...
I cant connect to the Database WebAdmin. If I click the icon, i got an "File not found." in the opening tab. Back in Plesk I get the following:
ERROR: PlexkFatalException
Server id is undefined?
I even cant connect via ssh to the mysql part of my server. But the server is running and both of my two wordpress pages run smoothly. I know this page: [URL] .... – but as I sad, cant enter die mysql.
It seems something is wrong with the permissions. I'm on the point where I just want to reset everything database related. But how?
This is on a CentOS 7.1, Plesk 12. New.
On Plesk 10.4 I had a script that backed up my MySQL databases separately. The script doesn't work now. I get an error:
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Do I need to do something different with this new "MariaDB" thing?
Here's the script:
DB_BACKUP="/pat/to/databackup/`date +%Y-%m-%d`"
DB_USER="admin"
DB_PASSWD="-p`cat /etc/psa/.psa.shadow`"
HN=`hostname | awk -F. '{print $1}'`
[Code] ....
What is the recommended method of backing up big MySQL database of size 2 GB ?
Quote:
# mysqldump gallery > gallery.sql
mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES
#
I checked the table, it is fine, but can't do the backup.
Quote:
mysql> check table 10tir_user_group;
+-------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------+
| gallery.10tir_user_group | check | status | OK |
+-------------------------+-------+----------+----------+
1 row in set (0.07 sec)
mysql>
I have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).
View 13 Replies View RelatedDue to LayeredTech price hike, i'm going to cancel my server with LT within two weeks.
Does anyone know an easy way to backup all the domians and mysql database in FreeBSD/DirectAdmin? Is there a built in feature in DirectAdmin that can do that?