Restore DB From SSH?
May 21, 2008I uploaded a .gz file that contains an sql file and was curious to know how I can restore it into a database via SSH.
View 5 RepliesI uploaded a .gz file that contains an sql file and was curious to know how I can restore it into a database via SSH.
View 5 RepliesWould like to know what are the dangers of backing up and restoring full entire system backups (with plesk installed) to another server with a different ip address? Will the restored plesk setup operate properly and offer an ip address change in the system, or will there be any pre-requisites required such as manual ip changing within the system core files?
View 1 Replies View RelatedI do not have a restore disk for my Toshiba laptop and there is a virus on it. Can I use my restore disk from my HP computer? Both use windows XP?
View 4 Replies View RelatedHow do I install an SSL Cert with just the .key and .crt in root WHM?
View 5 Replies View Relatedi deleted the files db files in /var/named/
how could i can restore it?
what i want is how can i recreate the dns zone files again for all my accounts in the server
note : i have whm/cpanel running on centos box
I use WHM to do nighly full backups of all my accounts. One one account (my own web site) I want to restore ONLY a certain directiy and its subdirectories. Is this possible or do I have to restore the entire site? If so, how?
View 4 Replies View RelatedI have dedicated server and I have daily,weekly and monthly backups located in:
root: /backup/cpbackup (my secondary drive)
each account's backup locate in specific directory like:
the backup of account website1.com will be located in:
root: /backup/cpbackup/website1
all backups are not compressed file
So, How can I restore one or more backup?
I've come into a bind here.
I need to restore a deleted VPS. Problem is that another VPS was created right after the VPS was deleted. This is on a Xen hypervm slave.
I tried running vgcfgrestore -f /etc/lvm/archive/VolGroup00_01381.vg VolGroup00
but its not bringing back the files.
Any ideas at all at on how to recover? Is this even possible? I just need to salvage some files from /home from the old setup.
Perhaps delete the new VPS and then do a restore?
I have on my server vBulletin 1.7GB database in SQL format I try somany time to restore it but its hang! I transfer that file to another server and its working fine!
I see the MySQL Processes:
Code:
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
| 11 | leechprotect | localhost | leechprotect | Sleep | 2073 | | |
| 22 | eximstats | localhost | eximstats | Sleep | 1902 | | |
| 25 | xxxtyyx_vb | localhost | xxxtyyx_vb | Query | 1494 | Repair with keycache | /*!40000 ALTER TABLE `post` ENABLE KEYS */ |
| 41 | root | localhost | | Query | 0 | | show processlist |
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
Its stay like that for long time!
I take full backup of one site. the site have 250 mb database mysql i click on backup restore inwhm and select site and whm say Restore done. ut mysql can`t restore good
how may i restored the site full?
root@server [~]# mysql -u divingho_dhadmin -p divingho_divinghols < /home/divingho/mysql/divinghols.sql
Enter password:
ERROR 1044 (42000) at line 11: Access denied for user 'divingho_dhadmin'@'localhost' to database 'divinghols'
The username is right, the password I use is correct. I even deleted, recreated the mysql database and username, still giving the same error. The path to sql file is right and only 68k in size.
Using mysql 4.1
i was make a os reload and i amount the old drive in my server i can see my old files in /home but the problem how can restore it?
View 8 Replies View RelatedHow long should a cpmove (full backup) take to restore for a site that is 4GB? Its been "Extracting Tarball" for about 3 hours now, and has stopped updating the transcript with "..." for a while. Is this normal or do I need to start a fresh copy?
View 5 Replies View Relatedrestore a big mysql database (vbulletin) but the sql backups are all in smaller files, 200+
root@server [/home/user/public_html/db-backup/2007-09-17]# mysql -u user_user -pACTUALPASSWORD user_vbulletin < /home/user/public_html/db-backup/2007-09-17/*.sql
-bash: /home/user/public_html/db-backup/2007-09-17/*.sql: ambiguous redirect
How do I do all in one shot safely?
using mysql 4.1
I transferred my account over using pkgacct and then issued the command: /scripts/restorepkg username
It split a lot of these errors below:
Code:
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000164.mbox:2,: Cannot change ownership to uid 0, gid 0: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000157.mbox:2,: Cannot utime: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000157.mbox:2,: Cannot change ownership to uid 0, gid 0: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000162.mbox:2,: Cannot utime: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000162.mbox:2,: Cannot change ownership to uid 0, gid 0: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000161.mbox:2,: Cannot utime: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000161.mbox:2,: Cannot change ownership to uid 0, gid 0: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000160.mbox:2,: Cannot utime: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000160.mbox:2,: Cannot change ownership to uid 0, gid 0: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000109.mbox:2,: Cannot utime: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/cur/1170637674.000109.mbox:2,: Cannot change ownership to uid 0, gid 0: No such file or directory
...............
...............
...............
...............
...............
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/.spam/cur/1170637676.000037.mbox:2,: Cannot utime: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/.spam/cur/1170637676.000037.mbox:2,: Cannot change ownership to uid 0, gid 0: No such file or directory
...............
...............
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/.spam/cur/1170637676.000025.mbox:2,: Cannot utime: No such file or directory
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/.spam/cur/1170637676.000025.mbox:2,: Cannot change ownership to uid 0, gid 0: No such file or directory
...............
/bin/tar: cpmove-john/homedir/mail/mywebsite.com.com/celine/.spam/cur/1170637676.000211.mbox:2,: Cannot utime: No such file or directory
/bin/tar: cpmove-john
it shows this error for all files inside the /mail/ directory. Any idea what's wrong? The restore process is still running, haven't gotten past this yet.
I Have Send To Zone.net For My Backup Before 4 - 5 Days!
Is That Just Happen With Me?
Or Where The Support Team Or Any Supporting They Call It?
Hope Anyone Make It Faster To Get My Backup Back ....
Backing up a server is obviously very important. Lets say I do a daily rSync backup and eventually my server HDD crashes, I know it isn't just a 'one click' job to restore my backup but what is it necessary to do in order to carry out a complete and effective restore back to how it was?
A step-by-step 'tutorial' on restoring an rSync backup would be helpful not just to me but to many 'would-be' server administrators.
The only backup I could get from crissic was my hypervm backup...
Can anyone tell me if it's possible to just restore this backup on a new VPS and have the code and mysql back to life? At the moment i've looked into the backup and can see the html files and the mysql database files.
How can create backup fron an openvz vps and resote on another openvz based server?
View 3 Replies View Relatedi have a centos with cpanel server,
it may be the board problem,it could not work now.
i install another centos server with cpanel,
how can i restore fron the hd of original server to the new one well?
by mistake i have deleted following files how can i restore them. as it was
public_html/themes/index.php: destroying......done
public_html/themes/admin/index.php: destroying......done
public_html/themes/lib/phpthumb/index.php: destroying......done
public_html/themes/lib/phpthumb/cache/index.php: destroying......done
public_html/themes/lib/phpthumb/cache/source/index.php: destroying......done
public_html/themes/lib/exifer1_4/index.php: destroying......done
public_html/photogallery/docs/index_fr.htm: destroying......done
Does anyone know of a hoster that offers Bare Metal Restore/Recovery?
View 5 Replies View Relatedim currently in the process of movinmg most of my clients MySQL dbs to a dedicated mysql server (direct private lan link so speed/bw is not an issue) but i have ~2900 .sql files i need to restore, anyone got any idea how to automate this restore,
the sql files were created suing mysqldump on old server so have all the appropriate create database entries etc but id rather not have to do each file by hand or ill be here for months
i have install nttack on my windows server.
i want to creat backup from my server (nttack and ... )
that i can restore it on my other vps.
i want to trasnfering.
and so creat backup and then restore is good for trasnfering and on certain vps good for securety.
how can i do it? i mean creat and restor.
I have a new customer moving from another host. His account was terminated already, so just have backup file. When restoring his mysql database, I have this error
Quote:
Unable to restore database dbname.sql to agesuke_forum : ERROR at line 521 in file: '/backup/dbname.sql': Unknown command ''.
Googling shows error in version < 5.0.6 but we are using 5.1.35 already. Is there any idea to fix? This account will run on CentOS 5 - 64bits, FYI.
i found out that for the past 6 months ive been backup up all my MySQL databases into one big file. However, now that i actually need to restore a database, i can't find out how to actually restore 1 database out of this enormous file.
I can find the Mysql shell command to restore 1 database ... but it doesnt tell me if you need to have a 1 database dump file for this as well. It does not mention what happens if you execute that command on the big file containing all databases. Restoring all server databases would be a very bad thing.
if you have used BQ internet remote backup
If you loose a DB how do you use BQinternet to restore the DB?
one particular DB
where is it stored?
Had a problem whereby the best solution was to ask support to restore my VPS from the Virtuozo backup.
It has now been 2 days and no idea when it will complete.
Seems excessive, or something wrong, but support just say "It is not uncommon for restores to take this long with the backup software we are using".
Just wondering, have any of you ever needed to ask support to restore from backup, and how long did it take?
The amount of data is approx 30GB.
I have OS fail , now im install new OS on new HDD, how can i mount and get data from fail hdd ?
Here is info:
[root@server-210-245-124-170 ~]# fdisk -l
Disk /dev/sda: 250.0 GB, 250059350016 bytes
255 heads, 63 sectors/track, 30401 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 1971 15727635 83 Linux
/dev/sda3 1972 3929 15727635 83 Linux
/dev/sda4 3930 30401 212636340 5 Extended
/dev/sda5 3930 9151 41945683+ 83 Linux
/dev/sda6 9152 13067 31455238+ 83 Linux
/dev/sda7 13068 14111 8385898+ 82 Linux swap / Solaris
/dev/sda8 14112 14372 2096451 83 Linux
/dev/sda9 14373 30401 128752911 83 Linux
Disk /dev/sdb: 250.0 GB, 250059350016 bytes
255 heads, 63 sectors/track, 30401 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 * 1 30401 244196001 8e Linux LVM
Disk /dev/sdc: 250.0 GB, 250059350016 bytes
255 heads, 63 sectors/track, 30401 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdc1 * 1 13 104391 83 Linux
/dev/sdc2 14 30401 244091610 8e Linux LVM
[root@server-210-245-124-170 ~]#
/dev/sdc is old HDD with OS failed. I wanna mount is and all data to /oldroot folder for copy and restore data.
I've restored a cpmove file copied from another server and I notice that many site files are missing. However, there were no errors during the restore process in WHM.
When I try to manually gunzip the file, I get an "unexpected end of file" error.
Questions -
1. If the file is corrupt or was transferred in ASCII instead of binary, would any of it have been expected to restore properly? For example, I can see the database content is valid, as are some of the php files and such.
2. I no longer have access to the source server. Is there a way that this file can be repaired?
3. Why didn't WHM report any error when extracting the tarball?
how do i restore a raid 1 if one disk fails? or to be more specific if a disk is unplugged while the machine is still running xD. The madman of my boss wants to see what happens... well the raid responded and the system is still functioning with one disk... but how do i put a new one? just plug it and that's it?
my OS is centos 5.1 and i have mdadm as a raid tool