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

Source: Internet
Author: User
Tags 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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.