When a mysql database recovery (* frm) file uses a virtual server, the server provider generally does not use Import and Export (such a file suffix is *. SQL) as we use a local database ). Most of the time, a folder is provided, including the database name folder, including *. frm, *. MYI, *. MYD, and a db. opt file. We will introduce them separately:
*. Frm ---- describes the table structure.
*. MYI ---- table index
*. Myd ---- saves the table data records
Db. opt ---- open it in a text editor and you can see that the encoding information is saved in it.
To import the above database into mysql:
- Install mysql database: the database I installed is MySQL Server 5.5. Select D:/program files/MySQL as the installation directory (note: do not include Chinese characters in the path)
- In C:/Documents and Settings/All Users/Application Data/, find the MySQL/MySQL Server 5.5 folder, which has a file: my. ini
- Find a datadir key in the my. ini file, for example, datadir = "C:/Documents Ents and Settings/All Users/Application Data/MySQL Server 5.5/data/"
- In the data folder found in 3, copy the files (including *. frm, *. MYI, *. MYD, db. opt) provided by the service provider for backup)
- Restart the mysql service to view the table structure and data on the management interface.
