Import MySQL Files into new database

**adurstew** · 06-13-2003

Is there a way to import the MYI, MYD and frm files from a pre-existing table into a new table?

Reason being. MySQL 3.23 crashed on me and all I have left are the tables. I am going to install MySQL 4.0 but I can't get MySQL 3.23 running to do a dump.

Any ideas?

Thanks,
Andrew J Durstewitz

**caffeine** · 06-13-2003

Sounds bad. Maybe you could recreate the database, complete with tables, then shutdown the database and replace the appropriate MYI, MYD and frm files.

I've not tried this but it should be easy to try. Just make sure you make backups of your original MYI, MYD and frm files.

**Dolda2000** · 06-13-2003

As I have understood this MySQL storage engine thing, you should be able to just copy those files from the old DB server to the new one directly. I'm not sure if the file format has remained unchanged over the version change, but it's not impossible. As long as you have a backup, it won't hurt to try, though, right?

**genlee** · 06-13-2003

If it crashed, have you used myisamchk to try and repair it?

Thread Tools

Display

Import MySQL Files into new database

Posting Permissions