Plesk 11.x / Windows :: Out Of Memory Error When Restoring Database From Repository
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
ADVERTISEMENT
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
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
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
Feb 5, 2008
SQL query:
/*!40000 ALTER TABLE `qhvbmailer_attachments` DISABLE KEYS */;
MySQL said: Documentation
#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 ';
UNLOCK TABLES;
--
-- Table structure for table `qhvbmailer_campaigns`
--
DRO' at line 1
View 8 Replies
View Related
Jun 29, 2013
After upgrade to Plesk 11.5.30 trying to set up FTP-Backup Repository:
Repository error: Transport error: unable to list directory: Curl error: Access denied to remote resourceClick to expand...
View 7 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
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
Mar 28, 2015
12.0.18 update #39
Server 2012r2
Logged into my panel today to run a database backup on a site I'm working on to be confronted with the following:
Unable to backup database 'XXXXXXXXXX'
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupXXXXXXXXX.co.nzdatabasesXXXXXXXXX-29 est'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.
(Error code 21)
I'm not sure why permissions would change on their own, I'm also not sure how to fix the permissions error. I get the same error on all databases.
PrivateTemp folder appears to have write permissions for Group MSSQLSERVER
View 6 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
Feb 21, 2015
I want to backup my server, but i get always error, when i want to save my Personal FTP Repository. I get following error:
Transport error: unable to list directory: Curl error: FTP: weird server reply
What is the reason?
View 6 Replies
View Related
Jun 29, 2014
I'm recieving the following error
"Transport error: unable to list directory: Curl error: Couldn't connect to server".
This happens when I enter ftp settings for the Personal FTP Repository. I'm sure the ftp server is fine. I have it already set on other domains. It connects backs-up just fine.
I've noticed two things when connecting to the FTP server it automatically issues PASV and does nothing else. It also connects using the secondary ip which I guessing it should. Micro Update 5 is installed.
View 10 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
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
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
Dec 17, 2014
I tried to import / restore a backup from dropbox but it was unsuccessful,
Restoration of the backup","status":Failed to Execute: "C:Program Files (x86)ParallelsPleskinpleskrestore.exe" --restore "C:Program Files (x86)ParallelsPleskvarmodulesdropbox-backupdomain.tld.tar" -level domains -filter list:domain.tld
View 3 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
May 31, 2008
how long does it take to restore 400 MB database though SSH, i check on phpmyadmin screen, and it has 79 tables only. the last table was post table.
View 1 Replies
View Related
Aug 18, 2007
Here's the situation:
Moving from VPS to Dedicated,
VPS (cPanel) and Dedicated (Plesk)...
I FTP'd all the files, what's left is the database.
I was going to restore the db using SSH, but I had to FTP it first, so I tried but half-way it would time out (disconnect from server)
Right now I am trying phpMyAdmin, I doubt it will work.
Is there a way to transfer from cPanel to Plesk?
DB size is 400MB
View 3 Replies
View Related
May 5, 2009
How can my user use MSSQL management studio to restore the DB? Whenever my user try to browse for the db file, he can't browse to his own web folder due to permission error.
View 12 Replies
View Related
Apr 20, 2008
I am using fedora 7 and when i fire "yum localinstall dovecot-*" it gives error.
Could not retrieve mirrorlist [url]Error was [Errno4] IOError:< urlopen Error (110,'connection timed out')> Error:cannot retrieve repository metadata (Repomd.xml) for repository:fedora
i have checked all the setting but nothing.
View 6 Replies
View Related
Apr 9, 2007
Is there a way to restore a MySQL database from the files located in /var/lib/mysql?
Unfortunately I don't have a mysqldump of the databases, just the raw files from an image of the server.
View 3 Replies
View Related
Nov 24, 2007
I moved my site to a new host and am running IPB 1.3 forums,
I have a 62meg sql backup to restore.
I have tried using BIGDUMP.php as max upload is over 52megs.
No Joy!
I also tried zipping the file, got it down to 9megs,
It wont complete the upload in PhpMyAdmin?
I have not had to restore a back up before, and am really struggling.
View 4 Replies
View Related
May 12, 2015
it's starting to kill child processes and eventually stops/hangs.
#plesk version
Product version: 12.0.18 Update #45
Update date: 2015/05/08 03:13
Build date: 2015/01/26 15:00
Build target: CentOS 7
Revision: 334346
Architecture: 64-bit
Wrapper version: 1.2
#free -m
total used free shared buff/cache available
Mem: 3782 647 2281 45 854 2875
Swap: 2047 0 2047
View 1 Replies
View Related
Feb 12, 2015
I run few export procedures which take a long time ot process (lots of joined sql) and generate quite large output. Plesk 11.0.x required some php/fcgif adjustments but I got it to work.
Now I switched ot Plesk 12 and have to set it up again.
I started with Plesk / PHP Settings for this domain:
memory_limit set = 2G
max_execution_time = 600
max_input_time = 600
post_max_size = 2G
Default subscription has no setting for above values but I have added them per this domain os not sure why it ignores my 2G value?
Error:
mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 1047527424 bytes exhausted (tried to allocate 84 bytes) in
View 3 Replies
View Related
Jun 22, 2015
PleskLog File
104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server
[Mon Jun 22 15:33:11 2015] [error] [client 176.10.112.11] Premature end of script headers: import_cop.php
and Apache Log
[Mon Jun 22 11:06:57 2015] [error] server reached MaxClients setting, consider raising the MaxClients setting
[Mon Jun 22 15:46:17 2015] [error] (12)Cannot allocate memory: fork: Unable to fork new process
PHP Warning: Module 'zip' already loaded in Unknown on line 0
How can I fix this problem? The Script is 100% i/O because it has worked onder PHP 5.2 and its comp. whit 5.4.
View 12 Replies
View Related
