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?
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 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.
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?
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..
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
The mysql dir on my server seems to fill up sometimes and I see these files that aren't actually DB's. They all vary in size.
Quote:
u15149596-bin.000001
u15149596-bin.000002
u15149596-bin.000003
u15149596-bin.000004
u15149596-bin.000005
u15149596-bin.000006
u15149596-bin.000007
u15149596-bin.000008
u15149596-bin.000009
u15149596-bin.000010
u15149596-bin.000011
u15149596-bin.000012
u15149596-bin.000013
u15149596-bin.000014
u15149596-bin.000015
u15149596-bin.000016
u15149596-bin.000017
u15149596-bin.index
I can remove them and I see no problems with the server after that. Does anyone have any idea what these are?
I'm running Plesk 8.0.1
Basically mysql is behaving very very intermittently. Crashes were every 4 hours, I've brought them down to once every 8 or so hours but mysql keeps dying.
the error log will show the same routine each time.
on mysql start:
Quote:
091101 21:58:03 [Warning] option 'open_files_limit': unsigned value 120000 adjusted to 65535
091101 21:58:03 [Warning] Could not increase number of max_open_files to more than 65535 (request: 200110)
091101 21:58:03 [Note] /usr/sbin/mysqld: ready for connections.
Then we'll see errors due to crashed databases:
Quote:
091102 0:33:07 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './<nameofdatabase.frm>'
following this a heap of:
Quote:
091102 0:36:35 [ERROR] /usr/sbin/mysqld: Can't open file: '>another database here.frm>
091102 0:36:36 [ERROR] /usr/sbin/mysqld: Sort aborted
091102 0:36:52 [ERROR] /usr/sbin/mysqld: Sort aborted
091102 0:43:00 [ERROR] Error in accept: Too many open files
I have the files .myd .myi and .frm files in a archive .tar.gz
My host do not provide shell access.
Is the any way that i can convert the files into .sql queries
Or is there any method other that using shell access.
Or is there any software to convert the database files into .sql query in my desktop computer so that i can restore it using phpmyadmin
My site has been down from several days
I been having a heck of a time just with this one cpanel server and open files limit. At first using open_files_limit did not work so I changed it to open-files-limit that seemed to work but now it rejects the value and sets its down to 65535.
Then system open files limit is 500000. I try to set it to any value about 65535 in my.cnf and here is usual error:
090630 9:32:07 [Warning] option 'open_files_limit': unsigned value 120510 adjusted to 65535
090630 9:32:07 [Warning] option 'open_files_limit': unsigned value 120510 adjusted to 65535
When I run something like the tuning-primer it shows:
Current open_files_limit = 120510 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
But Im not sure if it is just reading my.cnf or something. I am still getting complaints from users about lost connections and I see the errors in error log. Ive looked everywhere and cant seem to find a solution to this.
I'm trying to use the "mysqldump" command to get a copy of all databases on the server...
but I need each database to go into a "databaseXYZ.tar.gz" file.
Does anyone know how to do this? So far, I can only get all the databases into a single file. But I need each database to have its own file.
I have following problem-i have over 20 sites on server and each site has own database.Is there a way to speed up backup and transfer or other server?
Method which i use right now it's following:first i archive entire directory using command tar -pczf name.tar.gz public_html,and then repeat with each directory.But i think i could simply archive all requied directories,but that will took toomuch time,so if i drop connection during archiving it wont be archived at all then.So i think best solution will be to create some kind of batch command which can load in background,so that means command wont stop if client lost connection.
So let's say i have 2 sites and two directories located and different places.
One is at home/site1 and other at home/site2
So i think i would need to put command into batch file
tar -pczf site.tar.gz. /home/site1 and tar -pczf site2.tar.gz /home/site2
Will that work? Also second part,mysql databases,i founded if i login into phpmyadmin as root i can see all databases.I managed to export all databases,but question will import again to phpmyadmin work.I think phpmyadmin create command for each database "if there is no db sitename_mysqlbase,create it",but howmuch i know phpmyadmin have limit with importing size of mysql database.Could that be done with import/export mysql command?
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies View Relatedhow 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 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
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 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
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?
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.
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.