MySQL backup?

Discussion in 'MySQL' started by asgsoft, Aug 29, 2008.

0
  1. #1
    hey evryone!

    I am a bit stuck here!

    I have a cPanel backup of a databse which I am trying to restore.

    Does anyone know what's the best way to do it? it's a tar.gz file.

    I tried extracting it but it has .MYD and .MYI and .FRM files.

    Any ideas on how I can get the data back in sql?

    Thanks
     
    asgsoft, Aug 29, 2008 IP
  2. dynashox

    dynashox Premium Member Staff

    Messages:
    8,662
    Likes Received:
    563
    Best Answers:
    3
    Trophy Points:
    335
    #2
    Have you try to "Import" the database?
     
    dynashox, Aug 29, 2008 IP
  3. asgsoft

    asgsoft Well-Known Member

    Messages:
    1,737
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    160
    #3
    yes

    I get a HUGE error message which doesn't make sense
     
    asgsoft, Aug 29, 2008 IP
  4. toraton

    toraton Peon

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If you drop those three files into mysql's data directory and make sure the permissions are correct then it should work fine.
     
    toraton, Aug 30, 2008 IP