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.

MySQL Databases Question (Help!)

Discussion in 'General Discussion' started by mlin, Nov 14, 2003.

  1. mlin

    mlin Member

    Joined:
    Nov 10, 2003
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    How do you use downloaded MySQL client to convert MYD/MYI files to .SQL files that could be uploaded via PHPMyAdmin?

    Particularly, what are the command lines?

    Thanks!
     
  2. mlin

    mlin Member

    Joined:
    Nov 10, 2003
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
  3. SarcNBit

    SarcNBit Well-Known Member

    Joined:
    Oct 14, 2003
    Messages:
    1,010
    Likes Received:
    3
    Trophy Points:
    38
    Do you have the '.frm' files?
     
    #3 SarcNBit, Nov 15, 2003
    Last edited: Nov 15, 2003
  4. SarcNBit

    SarcNBit Well-Known Member

    Joined:
    Oct 14, 2003
    Messages:
    1,010
    Likes Received:
    3
    Trophy Points:
    38
    You will need to rebuild the database before creating a dump.

    Once the database is rebuilt, you can use

    mysqldump YOURDB > yourbackup.sql

    You will need the .frm files to rebuild the database. Once you have all the files you need to manually CREATE the DB and then RETORE the individual tables using your data
     
Loading...

Share This Page