A MySQL database creates a number of different data files in the mysql data directory (typically
I believe these files are created for both MyISAM and InnoDB table
types because the MySQL documentation references these types with
respect to MyISAM and I definitely see them on my InnoDB tables.
If these are MyISAM tables, then plopping the .FRM, .MYD, and .MYI files into a database directory (e.g.,
How to restore DB using this files
http://stackoverflow.com/questions/5745221/import-frm-and-opt-files-to-mysql
/var/lib/mysql
). The following are the differences between the data files created:File Extension | Purpose |
---|---|
.frm | table definition |
.MYD | table data |
.MYI | table indices |
If these are MyISAM tables, then plopping the .FRM, .MYD, and .MYI files into a database directory (e.g.,
/var/lib/mysql/dbname
) will make that table available.How to restore DB using this files
http://stackoverflow.com/questions/5745221/import-frm-and-opt-files-to-mysql
Aucun commentaire:
Enregistrer un commentaire