Plesk 11.x / Windows :: Restore Database From Server Repository Zip
May 2, 2013
I have daily backups for all accounts setup on our Plesk 11 server and was wondering how I would go about restoring a single database from the backup manager? I could restore the entire zip file, but that would make a mess of any other databases which of course isn't optimal. I see if I download a client's zip file that within the zip_file/databases/db_name there is another zip file which contains a tmp file which for a MySQL database it looks fairly standard, for MSSQL it looks to be in their format but is this what's really necessary? Can I even use those tmp files to restore manually through the Backup Manager -> Database Backup Repository? Why isn't there a simple way for a client to restore a database with the existing backups?
I'm trying to restore a 600MB database which was uploaded to the repository in plesk. This database backup did NOT originate from this server, but rather I'm attempting to overwrite a blank database that was created with the same name via plesk.
The site is one of our web-spaces (not a customer subscription) so I am logged in as the plesk administrator.
System Info: Plesk 11.5 Windows 2008 R2 (64Bit) 3GB RAM MySQL 5.1
Full Error: dbbackup failed: Unable to restore database 'databasename' Exception of type 'System.OutOfMemoryException' was thrown.
I have tried altering the php.ini the PHP settings of the site (even though I'm logged in as the adminsitrator) as well as the php.ini of: C:ParallelsPleskadminphp.ini
memory_limit=2048M
It fails with the error after about 1GB of RAM usage on the server.
Trying to restore a database in plesk 11 I got the following error.
Error: dbbackup failed: Unable to restore database 'database_name'Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
There is no wrong with the db, when I restore from it on local machine everything works.
I have a problem with restore ms sql server 2008 database after restoring the message...Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror
I installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
Unable to restore database '17' Not valid backup: Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.). VERIFY DATABASE is terminating abnormally.
(Error code 22) ---------------------- Debug Info -------------------------------
I set up a FTP backup repository today however when attempting to restore selected objects from the backup there are a couple of messages that state:
"Restore the backup file despite a corrupted signature"
"You can select objects to restore only when you are restoring from backups that were created in Plesk 12.0 or later."
I noticed that the backup residing in the FTP repository has a .tar extension whilst the one I did in the server repository has a .xml extension.
Restoring selected objects from the server repository works fine.
Why is this not possible? I'd like to restore selected objects from the FTP repository. Otherwise I'll have to transfer the backup file from FTP repository to the server which is really inefficient.
First of all I checked via command line if any software is not installed properly while plesk installation was done on destination server (windows server 2012 R2). All looks fine, please check attached file pleskinstallation.txt
Source plesk version 10.4.4 (windows server 2008) Destination plesk version 12.0.18 MU#23 built.
We are in testing mode of migrating websites hosted with source plesk version 10.4.4 onto destination server plesk server 12.0.18 having (windows server 2012 R2).
What we did, we restored the backup of Source plesk version 10.4.4 (windows server 2008) to Destination plesk version 12.0.18 MU#23 built.
Now the problem is that backup which we restored on Destination plesk version 12.0.18 MU#23 was of 68 GB and now when we setup the backup on Destination plesk version 12.0.18 MU#23 and when backup completes successfully it show us wrong backup size up to 16 GB.
We have requested several times to plesk support has to check the entire new plesk version in terms of all feature (like taking backup, restoring, plesk installation etc) while releasing new version, If they have noticed bug than plesk support should not release new version or micro update until they are sure.
I would request them again to check backup size bug along with other bugs.
1. "Stats crashing and not updating stats"
2. installing "Spam assassin" on Plesk 12.0.18 on windows server 2012 r2 and we are getting error:
Error: Unable to set Plesk SpamAssassin 3.3.2 as the default Spam Filter: defpackagemng failed: Execute spammng.exe --check failed with error code 1: Unable generate the unique file name by template D:Program Files (x86)ParallelsPleskAdditionalPerlsiteetcmailspamassassinlocal.cf[*].bak: directory D:Program Files (x86)ParallelsPleskAdditionalPerlsiteetcmailspamassassin does not exist.
am trying to configure the repository to go the my FTP server at the home office. The home office is running Cerberus FTP server. From the remote server i can log into FTP from the command line and use WinSCP to login using sftp with no problem. When i try going through the repository page it just hangs. I have tried the passiv option as well. Is seems to hang at the LIST -a command. Here is the cerberus log below.
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.
Current Version Installed :Parallels Plesk Panel 11.5.30 Update #31 Problem: When username have @ like : myuser@mydomain.com
Steps : When configure the setting all go right (test to validate setting is ok too) , but when Scheduled Backup Settings using Personal FTP Repository cannot connect for server because the url use 2 @ like error message below.
Error Message : Cannot parse output file 'ftp://bk@mydomain.com@mydomain.com/' [Invalid URI: Can not parse the hostname.]
When I try to reset the Personal FTP Repository setting in Backup Manager, I get "Transport error: unable to list directory: Curl error: Failure when receiving data from the peer"
I've read a solution to this issue for Plesk for Linux, but not for Windows. I have my FTP server setup for FTPS (require explicit FTP over TLS) and when I put the correct information in each box, I get this error. In the meantime, the current settings (for standard FTP) are incorrect.
Obviously the most important this is to correct the Transport and Curl errors, but if I'm unable to do so, how do you clear the current setting? There doesn't seem to be a way to do it...
If I go into the Backup Manager, then click the "Personal FTP Repository", then click "Personal FTP Repository Settings", at the bottom it asks for a password and says how important it is to use a password.
So, I specify a password, then successfully do a backup to a remote FTP site.
But when I examine the backup.zip file at the remote FTP site, it a plain ZIP file that you can open without any password!!!
How is this secure, what's the point of asking us to specify a password when it's not used to password lock the backed up ZIP file?
We have Panel Plesk 11.5.30 in Windows 2008 R2. when you go to File Sharing in all the Subscriptions, appears this error: Internal error: Unable to access File Sharing repository with the system user name "admin": wrong username or password
This happen since we do the update to the new version 11.5.30 ...
Error: Test the database server connection failed:
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
After Plesk Panel upgrade to 12.x I found a warning showing at Home>Tools & Settings> Database Servers
Warning: Unable to determine the TCP port number used by Microsoft SQL server '.SQLEXPRESS': TCP/IP protocol is not enabled in the server network configuration or the server is configured to use dynamic TCP ports.
To allow your customers to automatically configure firewall for remote database access, manually configure the SQL server to listen on a specific fixed TCP port.Click to expand...
I'm having a problem with Plesk Panel 11.0.9 update #64. All other page running perfect. But when I go to "Backup Manager --> Database Backup Repository --> Upload Backup File" then Plesk Panel show error: Internal Server Error 500.0.
In Plesk 12.0.18 #4 I checked Grant the ALTER DATABASE permission to all Microsoft SQL Server database users . The problem is I cannot rename database tables or other functions with myLittleAdmin for SQL provided with Plesk.
My question is: Am I doing something wrong or is needed to upgrade the myLittleAdmin license to Full version?
I want to restore a database from my repository. In the backup manager (root) I have Server repository & Personal FTP Repository. The personal repository I set to backup every day. The server repository I don't know where to set the backup option. There seems to be some random backups every 2 weeks or so.
In the personal ftp repository I have the backups of the last 7 days as tar files. When I want to radio button "Selected objects" it can not me highlighted. I am on plesk 12.0.18. (I ticked "Restore this backup despite the fact that it does not have a valid signature")In the server depository the files are .xml and there I can select what to restore but the backups are not current. I need the database from yesterday.How can I make my personal backups selectable?
I have 2 identical servers: I'm trying to do backups from server1 to server2 and from server2 to server1.
In every server I setup a subscription just for storing backups.
If I configure Personal FTP Repository from server1 to server1 - the same server - it works (it gives a warning: backup on the same server is not safe).
If I try to configure Personal FTP Repository from server1 to server2 and vice versa, it gives me the following error:
Transport error: unable to list directory: Curl error: FTP: couldn't retrieve (RETR failed) the specified file
If I try to give a different password, it tells that the password is wrong: this means that server1 is able to connect to server2 and the ports are well configured (I hope).
If I connect in active mode from my PC with Filezilla to server1 or server2, same username and password, it works!
I'm not able to configure Personal FTP Repository and to backup to another server.
I host a number of large sites (20GB+) on my VPS server running Centos6 and Plesk Panel 12. Due to the large sites I don't want to keep multiple backups on the actual server because it would take too much disk space. When I create a backup to the server's repository all is good, but when I click the green arrow to download the backup it takes a long time and then it fails with a timeout error. On some smaller sites it takes a while but eventually downloads the tar.
So my question: Is it possible to access the Server Repository via FTP? How and where would I set this up? Presumably it would be a better way to download these large archive files?
Now what I want to do is restore 11 files from the backup. What I certainly don't want to do is restore the entire domain as I don't want to loose any changes since the last backup.
As it seems impossible to extract files from the archives.
When restoring a backup on Plesk 12, the error below is generated for some sites and the sites are only partially restored. Although the message talks about disk space, there is in fact plenty of free disk space - i.e. many GB. The backup was created on Plesk 11.5. The restore on Plesk 11.5 works.
I noticed that all the failed domains exceed the disk space allowed by their Service Plan. However, the 'Overuse is allowed' setting is selected. Strangely, I tried changing the Service Plan and retrying the backup and restore, and the same errors were generated.
<object type="domain" name="domain.com"> <object type="hosting" name="domain.com"> <message code="CantUnpackDomainContent" severity="warning" id="f3946c79-7ae2-4be2-8300-ba766bea7869"> <description>Can not deploy content of domain domain.com</description>
