General MYSQL copy. frm database file After viewing table hint table does not exist Error code:1146

Phenomenon:

After copying the source database folder with. frm to another MySQL environment, open MySQL, view the database and the table are all OK, but when you open the datasheet to view the table structure and table data, you are prompted for error code:1146, the data table to access "doesn ' t exist"

Solve:

In addition to copying the. frm source database folder, you also need to stop the MySQL service (either copy source or copy destination, the MySQL service is best to stop), and then copy the following 3 files in the same directory as the source database folder to paste or overwrite to the destination file before starting the MySQL service.

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/76/1E/wKioL1ZK3Sfg_TUhAAAqIxHOzwI505.png "title=" ocd9g0qh7m) t}%va7ys~z%u.png "alt=" Wkiol1zk3sfg_tuhaaaqixhozwi505.png "/>

Copy the above 3 files to stop the MySQL service as a prerequisite because: MySQL is buffered to write data to ibdata1, so at the time of copying without stopping the MySQL service may cause the Ibdata1 file is incomplete, and the destination because the MySQL service is running state, Causes the file program to be occupied, and thus cannot be copied.

General MYSQL copy. frm database file After viewing table hint table does not exist Error code:1146