Restoring VB Database 400 Mb Via SSH
May 31, 2008how 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
ADVERTISEMENT
Restoring Database
Aug 18, 2007Here'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
Restoring MSSQL Database
May 5, 2009How 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 RelatedGetting Error While Restoring Database.
Feb 5, 2008SQL 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
Restoring MySQL Database From Raw Files
Apr 9, 2007Is 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.
Restoring SQL Database Backup To Invision Power Board
Nov 24, 2007I 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.
Plesk 11.x / Windows :: Out Of Memory Error When Restoring Database From Repository
Jun 13, 2014I'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.
Restoring Backups ...
Nov 20, 2008how to restore an account from backups as my WHM backs up to an external server via FTP and I dont have a clue how to restore.
View 7 Replies View RelatedRestoring Email To A VPS
Aug 23, 2007I have an existing client with about 200 email accounts, I want to migrate all of them off of our server and to a VPS or something. They wil use a webmail to access them.
Is that possible?
Also, is it possible to give the client access only to create email accounts without giving them access to the whole hosting control panel?
Restoring Mailboxes
May 14, 2007I am in the process of migrating client's website and mailboxes.
My server is using Plesk 8.1 with horde as the default webmail applacation and had to install Squirrelmail beacause he was using this program integrated in his website.
I have been able to install it, configure it, it works both on Http and Https and i'm able to receive and send emails.
After this i'm trying to restore all the mailboxes into the new server (10 GB worth of mail) but i can't seem to find where to place that folder. I have tried google and looked everywhere suggested but can't find the folder where mails are stored I have been able to find the folder where the addressbook and config file for every account is located (/var/qmail/mailnames/DOMAIN/ALIAS) but there are no emails there despite the fact that they appear in the Inbox in Squirrelmail.
The server is running Debian 3.1 with Plesk 8.1 and Squirrelmail 1.4.4
Restoring Files
May 19, 2007I had my server with FDCservers and its back after 2 days of horrible downtime which according to them was due to hardware failure.
Server specs:
Intel Core 2 DUO E6600 @ 2.40 GHz
4096 MB RAM
400 GB HDD
cPanel
The old drive has Fedora 5 running with cPanel but on new drive, its CentOS 4.5 with cPanel.
Now, I want to restore the files from old(slave) drive to master(main on which centOS is running)
How do I do that? Isnt there any possibility since I changed the Operating System.
Restoring 1.5GB SQL Dump (Postgres)
Jan 23, 2007This seemed like the most appropriate place so I decided to post here.
SYSTEM:
Fedora Core 4, 3GHz, 2GB RAM
Postgres 8, Apache 2, PHP 4
The issue is that I have with me a 1.5GB SQL dump from Postgres 8 which I extracted using pg_dump.
Restoring it seems to be an issue on this PC. I've tried modifying memory directives in postgresql.conf as well as the kernels SHMAX value but no go.
I tried a bunch of other things such as gzipping the file so that it was only 100mb and doing:
Code:
gunzip -c dump.sql.gz | psql my_db
But I recieved many errors saying "invalid command N" and I also got a syntax error notice and the process terminated.
I tried to at least try and enter some data manually but vim is incredibly slow since this is a 1.5GB file.
Is there a way I could perhaps split up my db dump and then import them into the db one by one?
Restoring Mysql Db From .frm, .MYD, .MYI Files
Jun 21, 2007I did the absolutely most stupid thing yesterday, I emptied the wrong mysql table via phpmyadmin. Fortunately my host managed to grab a the table in question from a few days ago.
So I have:
auctions.frm, auctions.MYD, and auctions.MYI
My assumption, is that I can just overwrite the current files of the same name in the mysql folder, and everyone will be happy. Is there some more to this process?
Password Mismatch Error On Restoring Db Via Ssh
Apr 7, 2009Trying to restore db for my friend, was able to back up db via ssh using the username and pwd, but while restoring db in a new host get : Password mismatch error,
View 0 Replies View RelatedE2label (Restoring Backup From Old Primary)
Apr 19, 2008I have a smart error of possible hard drive failure on a hard drive of a cPanel server. Before I ask for replacement of new drive,
I'm going to get a new hard drive as New Primary
and make the Old Primary as Secondary Drive (To Restore)
I have the complete manual to restore. However the last time I tried to do that same thing, the system OS crash because it cannot tell which one is primary, and which is secondary (Both is SATA)
My partition is
/boot 100mb
swap 2gb
/tmp 500mb
/ rest of disk
no LVM, installed on MBR
I remember the last time I read something about e2label to rename my hdd label which cause the OS crash when new+old primary was booted together.
Error With Mysql While Restoring Account
Aug 12, 2008I was trying to restore an account via SHH and I get this message while the process arrived at restoring databases:
Quote:
ERROR at line 4236: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 4237: DELIMITER must be followed by a 'delimiter' character or string
Done
Restoring database roundcube......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'roundcube'; database exists'
ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 33: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 77: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 120: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 121: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 163: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 164: DELIMITER must be followed by a 'delimiter' character or string
Done
Restoring database horde......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'horde'; database exists'
ERROR 1146 (42S02) at line 23: Table 'horde.turba_objects' doesn't exist
ERROR 1146 (42S02) at line 24: Table 'horde.turba_objects' doesn't exist
ERROR 1146 (42S02) at line 25: Table 'horde.turba_objects' doesn't exist
ERROR at line 31: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 66: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 67: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 68: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 69: Table 'horde.horde_prefs' doesn't exist
ERROR at line 75: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 110: Table 'horde.kronolith_events' doesn't exist
ERROR 1146 (42S02) at line 111: Table 'horde.kronolith_events' doesn't exist
ERROR 1146 (42S02) at line 112: Table 'horde.kronolith_events' doesn't exist
ERROR at line 118: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 119: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 153: Table 'horde.kronolith_storage' doesn't exist
ERROR 1146 (42S02) at line 154: Table 'horde.kronolith_storage' doesn't exist
ERROR 1146 (42S02) at line 155: Table 'horde.kronolith_storage' doesn't exist
ERROR at line 161: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 162: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 196: Table 'horde.mnemo_memos' doesn't exist
ERROR 1146 (42S02) at line 197: Table 'horde.mnemo_memos' doesn't exist
ERROR 1146 (42S02) at line 198: Table 'horde.mnemo_memos' doesn't exist
ERROR at line 204: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 205: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 239: Table 'horde.nag_tasks' doesn't exist
ERROR 1146 (42S02) at line 240: Table 'horde.nag_tasks' doesn't exist
ERROR 1146 (42S02) at line 241: Table 'horde.nag_tasks' doesn't exist
ERROR at line 247: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 248: DELIMITER must be followed by a 'delimiter' character or string
Done
What does this error mean and how to solve this problem?
I have updated cpanel and mysql but the problem is still found
This problem found while trying to restore any account not this one only..
Phpmyadmin: Restoring MySQL4 DB Into MySQL5 DB
Jul 5, 2007everything works fine after I restore mySQL4 DB on FC4 except that character encoding is not restored correctly, If I write new post after restore using characters ie. č, ć....etc they are displayed correctly but the ones from the restore aren't displayed correctly,
View 7 Replies View RelatedError When Restoring Reseller Privs
Jul 30, 2007i try to restore a backup from another hosting to my server and always get stucked on "restoring reseller privs"
i'm using restorepkg username and got this error
Code:
not a reference at /usr/local/cpanel/Cpanel/CachedDataStore.pm line 27
at whm i can transfer multiple account and select "skip restoring reseller privs" but in this case my old hosting doesnt provide ssh access.
i was wondering is there any paramater to skip that?
something like
Code:
/scripts/restorepkg -somethingblahblah accusername
Postgres: Restoring A Filesystem Backup
Feb 19, 2007i had to do a file system back up because of the size of my database.
i shutdown postmaster and tar'd the files.
i recently reloaded my OS and now i'm attempting to restore the backups. i first shut down postmaster, restored the backups to the data folder and restarted postmaster.
i then su'd from root to postgres user:
Code:
[postgres@austin1 pgsql]$ psql service_2_3
psql: FATAL: database "service_2_3" does not exist
DETAIL: The database subdirectory "base/16385" is missing.
the backups had a database named service_2_3 but upon restoring the backups, it doesn't seem to be available.
my data directory is /var/pgsql/data.
Code:
[postgres@austin1 pgsql]$ ls -lahR /var/pgsql/ | grep 16385
but that yielded nothing.
have i done something wrong while backing up? i don't think i have since i followed the postgres manual when backing up. but the administrators have not been very thorough with how they've set the system up for me.
how i can resolve this issue if you have the time.
Restoring Accounts To Addon Domain
Jun 10, 2007Currently, 2 domains hosted on a dedicated server with each account having its own Cpanel. I'm going to move/migrate these 2 domains to a shared hosting server.
The shared hosting accont has Cpanel and I've added 2 Add-on domains (the same ones on the dedicated). In total, there are 3 domains under the shared hosting account; The main domain and the 2 other (add-on) domains.
My question is it possible to restore these 2 accounts under a single cpanel account and having all the emails intact? So, in essence, I'm having a single cpanel account to manage the 2 domains to be transferred from the dedicated.
Plesk 12.x / Linux :: Restoring From Another Installation
Jul 26, 2015I've had nothing but issues trying to restore a backup from another plesk installation.Running Plesk 12 on CentOS 6. I installed a php extension which required php 5.4. Yum updated our php version, which broke a couple of our sites. In trying to use yum to remove php 5.4, it also removed several components to plesk.
I then attempted to reinstall plesk and restore our backups from the previous day, but ran into several errors related to the way plesk hashes passwords in backups (as I now had a new key to hash against, they wouldn't work right). I solved that problem by running the fix passwords utility . But now I'm getting the following errors, I suspect the first one is the main problem.
WARNING: (server object '') Execution of /usr/local/psa/bin/sw-engine-pleskrun /usr/local/sb/utils/bru.php --restore --log=stdout --file=/usr/local/psa/PMM/tmp/sb54DVSHeFh.zip --target=server_settings failed with return code 1.
Stderr is
[code]....
Restoring Back Data From Hard Drive
Feb 16, 2007Does anyone knows any software or way to recover lost data from hard disk?
View 7 Replies View RelatedRestoring Incremental CPanel Backups To A New Drive
Jun 19, 2009We have incremental backups running in our server. We want to move the cPanel accounts to a new cPanel server and restore in that server. The Backup Restore option in WHM will recognize only compressed backups (like .tar.gz) when it is placed in the /home directory. So how do I do about restoring a incremental backup through the WHM of the new server?
View 4 Replies View RelatedRestoring Full Backups - CPanel And PuTTy
Jun 14, 2008I’ve just switched to a deticated server. I have backups of sites I need to move over and restore. cPanel has a “Restore a Full Backup/cpmove” option. Two questions…
1) How do I upload the back up file to the /home directory of my deticated server?
2) If the backup file is under a current client “/home/clienta” how do I restore it?
I’ve also tried using puTTy to restore the file.
- logged into as “root”
- typed “cd /home”
- typed “/scripts/restorepkg domainname”
BackupPC Restoring Files Without GUI Or Command Line
Mar 6, 2007I got our server staff to install BackupPC on our dedicated server and run daily backups. All is well (from what I can tell) but i've come to a point where I want to actually use an archived file.
So I jump into my ftp client, navigate to the backup folder, and download the file. The problem is, the file reads as jibberish. I'm assuming that BackupPC has compressed it.
So the question is two-fold:
1. How do I decompress it on windows (command line stuff is well beyond me)
2. Is there any browser/windows apps that I can use to manage the backups?