MySQL Databases Question (Help!)

M

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!
 
S

SarcNBit

Well-Known Member
Oct 14, 2003
1,001
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
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
F Search throught ALL MYSQL databases in WHM Databases 4
F Search for a specific word in all MySQL databases Databases 1
E MySQL® Databases Databases 2
M SOLVED Restoring MySQL Databases Question Databases 3
B Question regarding the mysql databases function within cpanel 11 Databases 1
Similar threads
Search throught ALL MYSQL databases in WHM
Search for a specific word in all MySQL databases
MySQL® Databases
SOLVED Restoring MySQL Databases Question
Question regarding the mysql databases function within cpanel 11
Top Bottom