USB enclosure MySQL data dump

Discussion in 'Site & Server Administration' started by bbrian017, Feb 6, 2010.

  1. #1
    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

    # mysqldump -u username -ppassword database_name > FILE.sql 
    Code (markup):
    IMPORT

    # mysql -u username -ppassword database_name < FILE.sql 
    Code (markup):
    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.

    mkdir /olddrive
    mount /dev/sdb3 /olddrive
    Code (markup):
    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...
     
    Last edited: Feb 6, 2010
    bbrian017, Feb 6, 2010 IP
  2. bbrian017

    bbrian017 Well-Known Member

    Messages:
    2,990
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    170
    #2
    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
     

    Attached Files:

    bbrian017, Feb 6, 2010 IP