XAMPP Accessing database Error!

Source: Internet
Author: User
Tags phpmyadmin
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 ?
MyISAMThe 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;
InnoDBThe 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

  • 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.