How to import files in frm, myd, myi format into MySQL

Source: Internet
Author: User
Tags phpmyadmin

When using a virtual server, the server provider generally does not look like we use a local database: Use Import export (such a file suffix is *.sql). Most of the time it is a folder, which includes: Database name folders, folders included, *.frm,*. myi,*. MyD, and contains a db.opt file. Introduce each:
*.frm--describes the structure of the table
*. Index of myi--table
*.myd--saved the data records of the table
db.opt--is opened with a text editor, and you can see that the encoded information is stored inside;
Frm,myd,myi is a file that is part of the MySQL store data, phpMyAdmin cannot be imported.
The file format supported by phpMyAdmin is a SQL file.

It's actually very simple:

1. Find your MySQL installation directory under the Data folder, create a new folder, folder name is the name of the library you want to design, put these files into this folder.
2. Then you can use your management MySQL tool to see what the table is.
frm format myd format myi file is the file that MySQL uses to hold the table, so it can only be placed in the MySQL installation directory of the data directory
And if you're going to upload space, it's basically impossible to recover unless you give the data to the space trader to help you recover.

Add:

In fact, a. frm file is a table in the corresponding database that represents the table structure of the datasheet.
. MyD file This should be a data file outside the InnoDB engine.
. Myi file:. myi is the extension of the index of the MyISAM table.
With a large number of select operations on the database, use the MyISAM table
The operation of the database has a large number of insert or update, using the InnoDB table

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.