How to import external frm, MYD, myi files to your own MySQL view

Many times, when viewing database files for certain projects, it is not common. sql files, but. frm,. MYD,. Myi These three files, this time a lot of friends do not know how to check.

PO Master is also in Baidu on the search, read an article after another, finally tinker out. Many published articles have said, we built the database files are placed in the MySQL installation directory in the data file , but ... Look, the PO master database can be more than 2 of these.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/5D/FC/wKiom1Uoh9rjYRBHAAHsahYW9EQ726.jpg "title=" _ 20150411103211.png "alt=" Wkiom1uoh9rjyrbhaahsahyw9eq726.jpg "/>

In this case, it is possible that the MySQL version of the different, PO main installed Here is the 5.6 version, installed in the C drive, if the installation path is not the same friend, please according to your own situation view

Now the 5.6 version of the import method, also under the Data folder, but is not the same path of the data folder, is in the C:\ProgramData\MySQL\MySQL Server 5.6\data (PO master, You see your specific situation)

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/5D/FD/wKiom1UojAGT8V27AAH5Mv8PSaE738.jpg "title=" _ 20150411105022.png "alt=" Wkiom1uojagt8v27aah5mv8psae738.jpg "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/5D/F8/wKioL1Uoi4-yNJH8AAOKYJPXdGA805.jpg "title=" _ 20150411103802.png "alt=" Wkiol1uoi4-ynjh8aaokyjpxdga805.jpg "/>

See, that's it, the circle is the PO owner built the database, and then this folder under a new file, whatever you name, such as BB. Copy the files of your frm/myd/myi name to the BB folder, then to phpMyAdmin or CMD, and other management tools, you can see the specific contents of the file you just imported.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/5D/F8/wKioL1UojFCgLyulAAFQdA_fB3o566.jpg "title=" _ 20150411104234.png "alt=" Wkiol1uojfcglyulaafqda_fb3o566.jpg "/>

This is ok .....

This article is from the "8507115" blog, please be sure to keep this source http://8517115.blog.51cto.com/8507115/1631149

How to import external frm, MYD, myi files to your own MySQL view