Import existing data tables in frm format to phpMyAdmin

Source: Internet
Author: User

When I was studying PHP and reading the module code in the book, I found that I could not find the database and copied the data files contained in the Code to the data directory under MySQL. So I want to open these existing data tables in phpMyAdmin to see how the situation is. I found that three files, such as frm and MRM, cannot be directly imported into phpMyAdmin. The Web Search Method replaces these files with SQL files. The method is as follows:

Copy the data table data_lyb, which contains the frm, MYD, and myi files to c: \ Documents ents and Settings \ All Users \ Application Data \ mysql \ MySQL Server 5.1 \ data.

Then run the doscommand, CD to enter c: \ Program Files \ mysql \ MySQL Server 5.1 \ bin, and then tap the command mysqldump-u root-P data_lyb> data_lyb. SQL

Enter the password and you will see a data_lyb. SQL file under the bin directory. All right, copy the file to c: \ Documents ents and Settings \ All Users \ Application Data \ mysql \ MySQL Server 5.1 \ data for ease of sorting. Here is an SQL file. Create a database named db_lyb in phpMyAdmin and import the db_lyb. SQL file to the database. The imported data tables are displayed.

 

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.