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.