MySQL Databases Question (Help!)

mlin

Member
Nov 10, 2003
6
0
151
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!
 

SarcNBit

Well-Known Member
Oct 14, 2003
1,010
3
168
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