The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to restore mysql dat from old harddisk [not from backup, running data]

Discussion in 'General Discussion' started by naveen3, May 25, 2005.

  1. naveen3

    naveen3 Active Member

    Joined:
    Jan 28, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    My server crashed last night.
    it was running only 1 website with php and mysql.
    I took backup 5-6 days back before crash, so the backup is not current [updated]
    I ordered for restore.
    and they put primary harddisk as slave [seconday] now.

    Let me know , how i get data from old mysql database and put it in the running mysql ?

    -Naveen
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Backup what you have now if you care about it. Mount the slave drive. Shutdown MySQL. Copy over the content from the old /var/lib/mysql* over to the live disk. Start MySQL.
     
  3. naveen3

    naveen3 Active Member

    Joined:
    Jan 28, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    thanks

    Thanks a lot buddy.
    u save me.

    these are the extra steps i fellowed -
    chown -R mysql mysql

    else it was giving some error.

    -Naveen
     
Loading...

Share This Page