Results 1 to 2 of 2
Operating System: CentOS 5
Processor: Intel Pentium 4 - 3.0 GHz
RAM: 1 GB
Total Disk Space: 120 GB
RAID: None
Bandwidth Quota: 500 GB
My server recently crashed and ...
- 02-06-2010 #1Just Joined!
- Join Date
- Dec 2009
- Posts
- 9
USB enclosure MySQL data dump
Operating System: CentOS 5
Processor: Intel Pentium 4 - 3.0 GHz
RAM: 1 GB
Total Disk Space: 120 GB
RAID: None
Bandwidth Quota: 500 GB
My server recently crashed and now I'm reprovisioning a new hard drive.
I paid the 150 USD to have a USB enclosure of the old hard drive.
How do I perform the following?
Export mysql from the websites on the hard drive?
EDIT: I found it.
EXPORT
IMPORTCode:# mysqldump -u username -ppassword database_name > FILE.sql
BUT Where does this stuff get exported to?Code:# mysql -u username -ppassword database_name < FILE.sql
How do I move it from the old hard drive to the new one?
So far I understand I have to mount the hard drive on to my new hard drive.
I can use all the help if anyone has some free hanging around and helping time.Code:mkdir /olddrive mount /dev/sdb3 /olddrive
I figure if I can get help with the first website the other 8 will be no problem...
- 02-06-2010 #2Just Joined!
- Join Date
- Dec 2009
- Posts
- 9
I managed to successfully mount the hard drive and visit it's /home/ root
Please see attachment.
Questions
Am I looking at the sql data or physical files such as html, tpl, and php?
If it's SQL Data how do I see the physical files such as html, tpl, and php?
If it's the physical files such as html, tpl, and php how do I see the sql data?
I ran this,
# mysqldump -u username -ppassword database_name > blogengage.sql
It seem to have worked but I'm not sure where it put blogengage.sql
Thanks,
Brian


