Home  >  Article  >  Backend Development  >  An error occurred when xampp accessed the database!

An error occurred when xampp accessed the database!

WBOY
WBOYOriginal
2016-08-04 09:20:371883browse

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!

1932 - Table 'phpmyadmin.pma__recent' doesn't exist in engine

Reply content:

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!

1932 - Table 'phpmyadmin.pma__recent' doesn't exist in engine

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn