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:
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.
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" ?
Since 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 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!
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.
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 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:
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 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;
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?
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).
Due 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?