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
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 RelatedHow 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 RelatedSQL 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
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.
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.
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.
how 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 RelatedI 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?
I 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
I 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.
This 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?
I 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?
Trying 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 RelatedI 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.
I 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..
everything 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 Relatedi 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
i 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.
Currently, 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.
I'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]....
Does anyone knows any software or way to recover lost data from hard disk?
View 7 Replies View RelatedWe 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 RelatedI’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”
I 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?