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?
View 2 Replies
ADVERTISEMENT
Jun 13, 2014
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.
View 1 Replies
View Related
Mar 30, 2015
When i try to restore a domain from Server Repository I am getting this strange error
Internal server error:
ERROR: Call to a member function write() on a non-object (Apache.php:821)
How could I fix it?
View 1 Replies
View Related
Dec 14, 2013
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.
View 2 Replies
View Related
Jun 24, 2015
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
View 1 Replies
View Related
Mar 8, 2015
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.
View 1 Replies
View Related
Jul 22, 2015
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 -------------------------------
View 1 Replies
View Related
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
Apr 9, 2015
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.
View 8 Replies
View Related
Nov 11, 2014
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.
View 1 Replies
View Related
Jun 17, 2015
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.
2015/06/17 19:11:07 [226] [FTPUSER] 230 Password Ok, User logged in
2015/06/17 19:11:07 [226] [FTPUSER] PBSZ 0
2015/06/17 19:11:07 [226] [FTPUSER] 200 PBSZ=0
[Code].....
View 5 Replies
View Related
Dec 15, 2008
when I run this command show me some errors what should I do?
# yum update
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
* plesk: www.atomicorp.com
* extras: mirrors.portafixe.com
* updates: mirrors.portafixe.com
* base: mirrors.portafixe.com
* addons: mirrors.portafixe.com[url]
[Errno 14] HTTP Error 404: Not Found
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: plesk. Please verify its path and try again
I have Linux with Plesk.
View 3 Replies
View Related
Dec 22, 2014
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.
View 1 Replies
View Related
Dec 10, 2013
new server, windows 2012 dataserver R2.
I set up the personal repository info and on save it hangs. Manual ftp to that other server works. Adding :21 to the address does not work.
View 14 Replies
View Related
Feb 2, 2014
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.]
View 1 Replies
View Related
Oct 10, 2014
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...
View 2 Replies
View Related
Jul 15, 2015
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?
View 8 Replies
View Related
Jun 22, 2014
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 ...
View 2 Replies
View Related
May 26, 2014
my plesk server was running OK for the last 13 months and suddenly it breaks apart on its own and I cant make it work again. [URL]
Is there a way to backup database at this stage? How?
Planning to reformat my windows server. and start over.
View 1 Replies
View Related
Feb 3, 2015
WINDOWS SERVER Plesk Panel version 12.0.18
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
View 1 Replies
View Related
Jun 23, 2014
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...
View 3 Replies
View Related
Dec 23, 2014
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.
On server, it show detail below: .....
View 2 Replies
View Related
Jun 19, 2014
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?
View 2 Replies
View Related
Oct 17, 2014
My backup ftp server was down, how do I move all backups from server repository to personal ftp repository?
View 5 Replies
View Related
Mar 27, 2015
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?
View 3 Replies
View Related
Dec 29, 2014
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.
S.O.: CentOS 6.5 (Final)
Plesk: 12.0.18 Update #30
View 3 Replies
View Related
Oct 22, 2014
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?
View 8 Replies
View Related
Oct 16, 2013
Next error:
C:Windows>"%plesk_bin%mchk.exe" --all --fix=all
Data error (cyclic redundancy check). (Error code 23) at BCryptDecrypt()
I restore all mail accounts from backup and use this command : "%plesk_bin%mchk.exe" --all --fix=all
How can I fix this?
View 3 Replies
View Related
Sep 20, 2013
I'm backing up a domain in Plesk Panel 11.0.9 on Windows, it's a large backup with 50,000+ images in it so the backup gets split into multiple zips
xxxxxx__xxxxxx.com_vhost_1309200100.zip
xxxxxx__xxxxxx.com_vhost_1309200100.zip1
xxxxxx__xxxxxx.com_vhost_1309200100.zip2
xxxxxx__xxxxxx.com_vhost_1309200100.zip3
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.
View 2 Replies
View Related
Dec 13, 2014
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>
[Code] .....
View 6 Replies
View Related
