Thread: 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

Code:

# mysqldump -u username -ppassword database_name > FILE.sql

IMPORT

Code:

# mysql -u username -ppassword database_name < FILE.sql

BUT Where does this stuff get exported to?

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.

Code:

mkdir /olddrive
mount /dev/sdb3 /olddrive

I can use all the help if anyone has some free hanging around and helping time.

I figure if I can get help with the first website the other 8 will be no problem...

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

Ouch, no external backup I take it?

no lol well actually I did for about 70% of my websites but not yawoop.com so I'm doing it all this way now!

I managed to export and import my first database now I'm about to move files. Lets see if this works.

Crossing my fingers for you.
Bet after this you're going to make sure you have an external back up

I run a mini server just for this purpose, to always make sure I have a backup of all sites.

I received an e-mail from the list. It seems like blogengage is back now. The transfer seems to be complete.

Originally Posted by bbrian017

It seem to have worked but I'm not sure where it put blogengage.sql

I think you have it all sorted out now, but if you have cPanel you can log into that account and use PHPMyAdmin to drop your SQL database.

oh jezzz what a mess that was!

I have 5 of my 9 websites back up.

I wish I could had dropped it into myphpadmin but ti's way to big. I have to use SSH command line because i"m on Linux.

If the server has cPanel there is a way to move an account from one server to another. It takes the databases with it and sets everything up as an exact clone. Doing things manually with SSH is a last resort for me, though it has to happen sometimes.

Wish I had a big enough HD on my backup server I'd offer WTF members accounts for backup purposes. Sadly I dont

It was actually the longest 18 hours in my life. See I had full back up of my large sites form the night before. But how often are you presented with an experience like this in a server environment.

I learned a lot but there's still so much more to learn using linux and SSH