Home >Backend Development >PHP Tutorial >An error occurred when xampp accessed the database!
The local C drive and D drive both have xampp. I copied the data of xampp/mysql/data under the C drive to the same location of xampp on the D drive. An error occurred when accessing the database table!
Unable to save recently used tables!
The local C drive and D drive both have xampp. I copied the data of xampp/mysql/data under the C drive to the same location of xampp on the D drive. An error occurred when accessing the database table!
Unable to save recently used tables!
Is your data table engine MyISAM
or InnoDB
? The suffix names of the data tables of MyISAM
are .frm
(table structure), .myd
(data) and .myi
(index). The index and data are separated and can be copied directly; The suffix names of the data tables of InnoDB
are .frm
(table structure) and .ibd
(data). Index and data are in the same file ibdata*
. They cannot be copied directly and need to be exported first. Import.
Don’t forget to restart the database service after copying.
For data files of MyISAM and InnoDB, please refer to: MySQL Data File Description
Direct copying is not possible. You need to export the database first and then import it