Find the answer to your Linux question:
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 ...
  1. #1
    Just 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

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

  2. #2
    Just 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
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
...