The local C and D drives have a xampp, I copy the xampp/mysql/data under the C disk to the XAMPP in the same location on the D drive, and an error occurred while accessing the database table!
Unable to save the most recently used table!
1932-table ' phpmyadmin.pma__recent ' doesn ' t exist in engine
Reply content:
The local C and D drives have a xampp, I copy the xampp/mysql/data under the C disk to the XAMPP in the same location on the D drive, and an error occurred while accessing the database table!
Unable to save the most recently used table!
1932-table ' phpmyadmin.pma__recent ' doesn ' t exist in engine
Is your data sheet engine MyISAM
or what InnoDB
?
MyISAM
The suffix name of the data table is .frm
(table structure), .myd
(data) and .myi
(index), its index and data are separate, can be copied directly;
InnoDB
The suffix name of the data table is .frm
(table structure) and .ibd
(data), index and data are all in the same file ibdata*
, cannot be copied directly, need to export and then import first.
Do not forget to restart the database service after the copy is finished.
Data files on MyISAM and InnoDB can be consulted: MySQL data File description
Direct copy is not possible. To export the database first and then import the