If I have the MySQL .frm, .MYD, and .MYI files, can I recreate the db without SQL?

I copied the data out of my /var/lib/mysql directory which has my database raw data in folders and has things like:

table1.frm
table1.MYD
table1.MYI

is this enough to re-import the databases to a fresh install of MySQL? Because I am about to re-image the server. if not, what should I do ?

Thanks!

Solution 1:

Check out:

https://stackoverflow.com/questions/879176/how-to-recover-mysql-db-from-myd-myi-frm-files

Solution 2:

The best option by far is to dump the existing databases to one or more text files and then import it/them into the new system. Mysqldump is the tool to use.

If I have the MySQL .frm, .MYD, and .MYI files, can I recreate the db without SQL?

Solution 1:

Solution 2:

Related

Recent Posts