An error occurred while accessing the xampp database!

Source: Internet
Author: User
The local drive C and drive D both have an xampp. I copied the data from xamppmysqldata under drive C to the same location as the xampp on drive D. An error occurred while accessing the database table! Unable to save recently used tables! 1932 the local drive C and drive D both have an xampp. I copied the data from xampp/mysql/data under drive C to the same location of drive D xampp. An error occurred while accessing the database table!

Unable to save recently used tables!

1932-Table 'phpmyadmin. pma _ recent 'doesn' t exist in engine

Reply content:

The local drive C and drive D both have an xampp. I copied the data from xampp/mysql/data under drive C to the same location of drive D xampp. An error occurred while accessing the database table!

Unable to save recently used tables!

1932-Table 'phpmyadmin. pma _ recent 'doesn' t exist in engine

Your data table engine isMyISAMOrInnoDB?
MyISAMThe suffix of the data table is. Frm(Table structure ),. Myd(Data) and. Myi(Index ),Its indexes and data are separated and can be directly copied;
InnoDBThe suffix of the data table is. Frm(Table structure) and. Ibd(Data ),Both indexes and data are in the same file.Ibdata *And cannot be copied directly. you need to export the file before importing it.
After the copy, do not forget to restart the database service.

For more information about MyISAM and InnoDB data files, see MySQL data file description.

Direct copy is not acceptable. you must first export the database and then import it.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.