Plesk 12.x / Linux :: Restore Backup Via PHPMyAdmin
Dec 6, 2014
I made a backup of my website with plesk backup manager on an external FTP, now I want to restore this backup on a new server which isn't using plesk, for test purposes. I've downloaded the backup (which is in .tar) on my PC, and extracted all files firstly from the general .tar archive, then the user_data from .tgz. Then to extract all the databases (they were in a folder "databases" after I've extracted the general .tar file), I extracted them from database_name_145536536.tgz, then from database_name_145536536.tar, so that now I've a series of "database_name_145536536" files. (145536536 are some example numbers).
I'm interested in restoring both files and mysql databases.
To restore the files, I can simply use the extracted files from the user_data archive.
To restore the mysql databases, I tried to do "mysql -p -u username database_name < file" and everything seemed to work fine.
Is this process ok? Is it 100% safe and sure or I could face some bugs?
i have make a full Plesk Backup on my Old Server with Plesk 12.0(Ubuntu) and will restore the Backup on my new Server with Plesk 12.0(CentOS).When i will restore the backup i get this error: "Error: The source file is not a valid XML file. If you supplied an archive file containing a backup from Plesk version 9 or later, then extract the contents of this archive, and process the extracted XML file with the converter. If you want to convert a backup file from a Plesk version earlier than 9, then you first need to process it with the pre9-backup-convert utility, and then process the resulting file with the pre10-backup-convert utility."
I've generated migration files on a source server that runs plesk11.5..I've transfer these files to my new server (plesk 12).I've logged into plesk on the new server, go to migration tool and create a new migration using local files.with chrome dev tools. i can see the following a post request is sent to :
/plesk/ server/migration/start/ the response is a redirection ( http status 303 , location = /admin/backup/restore/type/import/id/migration )a
After several attempts to this url I've got : admin/backup/restore/type/import/id/migration net::ERR_TOO_MANY_REDIRECTS..is there a way to restore the data using the command line ?
I am trying to restore a backup that Parallels Plesk made (latest version) and I used to get the option at some point to replace everything. Now, I only get the options to select what I want to restore and it fails because it says certain things, domains, content is already there.
I can't find the option anymore that allows me to say replace everything during the backup. Was that removed? If so, I'd really....really like it back.
Warning: Failed deployment of domain localhost.localdomain Warning: Execution of /usr/local/psa/admin/plib/api-cli/domain.php --create localhost.localdomain -owner admin -do-not-apply-skeleton -notify false -guid 4fe5de63-3103-4fa0-a01c-04894e167107 -vendor-guid 75b2fa01-6c6e-4cb2-8f1b-9c69757fd3ec -creation-date 2014-02-13 -ip 126.96.36.199 -ignore-nonexistent-options failed with return code 1. Stderr is An error occurred during domain creation: There are no available resources of this type (domains) left. Requested: 1; available: 0.
I have a repository backup that I want to partially restore. I see the option "Selected Objects" but it cannot be selected. I'm wondering why that is not an option? I'm also wondering what "restore this backup despite the fact that it does not have a valid signature" means. I see a check box. Is Plesk telling me my backup doesn't have a valid signature? What is the meaning of a "signature"?
Would like to know what are the dangers of backing up and restoring full entire system backups (with plesk installed) to another server with a different ip address? Will the restored plesk setup operate properly and offer an ip address change in the system, or will there be any pre-requisites required such as manual ip changing within the system core files?
After a server migration, some critical Plesk settings were not copied across, even though the option to backup/restore panel configuration was used. e.g.
skeleton (vhosts.skel folder) php.ini (Program Files (x86)ParallelsPleskAdditionalPleskPHP5* folder) Default site (vhostsdefault folder) health config (Program Files (x86)ParallelsPleskadminconfcustom-health-config.xml) Additional Administrator accounts
Is there a way to get these things to backup and restore that I am doing wrong?
Are there other important settings/data that I have missed from that list? I am still paying to keep the old server in case I discover something else!
Using Plesk Backup & Restore for disaster recovery will lose these settings unless they take extra steps. e.g. I now have a simple batch file that copies these files to a private folder on one of the domains before the daily backup kicks in.
Recently i installed the latest Multiple PHP functionality for Plesk and assigned PHP version 5.6 to a subdomain (for example demo.mywebsite.com) and i installed a Wordpress. So i thought i would try something out by installing a custom standalone version of phpmyadmin (version 188.8.131.52) and when i load the setup i ran into the following issue on the index.php page:
Code: Warning in ./libraries/session.inc.php#101 session_start(): open(/var/lib/php/sessions/sess_dubv0rqju6bejfplkgcsl98qsonviukg, O_RDWR) failed: No such file or directory (2) Backtrace ./libraries/session.inc.php#101: session_start() ./libraries/common.inc.php#352: require(./libraries/session.inc.php) ./phpinfo.php#12: require_once(./libraries/common.inc.php) note 1. Due to privacy i have called domain 'demo.mywesite.com' and subfolder 'root'
At some point, not sure when, PHPMyAdmin's (as accessed through the admin panel by clicking on a customer, manage hosting, databases, etc) permissions have changed such that I cannot view, edit or add MySQL routines/procedures. This appears to have occurred system-wide, though I have not checked every database on the server.
Is there a fix to get the permissions set so that I can make these changes again?
We are having an issue upload a 300mb mysql database to phpmyadmin.. With direct mysql file, t stops and only copies a few tables, stating to reupload to continue (which it doesn't and states that there are pre-existing tables). With zip file, it does the same.. at one point at 504 error occurred.
I'm on a VPS with Ubuntu 14.04 and Plesk 12 Web Admin Edition. I can't import a large (20 MB zipped) database dump to phpmyadmin because there is a 2MB file size limit. I suppose I have to change the server-wide PHP configuration (if I change the PHP settings for the domain nothing happens). Is there a way to change the global PHP settings via the Plesk panel?
under Plesk 12.0.18 PHPMyAdmin is failing to import a 3 MB SQL dump of a simple Joomla website. "Error 505 Bad Gateway", it says.It happens with other dumps too, some as small as ~500 KB. The format (SQL or ZIP) of the file uploaded doesn't seem to matter, because the upload itself seems to work; it seems it's the post-processing what is raising the error.
The funny thing is that the import itself seems to work (the contents of the SQL dump are imported), but the error message appears and causes confusion and support requests from our clients./var/log/sw-cp-server/error_log says:
2015/05/15 03:19:31 [error] 10215#0: *5 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: XX.XX. XXX. XXX, server: , request: "POST /domains/databases/phpMyAdmin/import.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "xxxx. xxxxxxx.com:8443", referrer: URL.....To me it sounds like a timeout.
This seems to be a "popular" error among Plesk users, and I have tried this, this and this with no luck.