Mysql packaging table prompts in phpmyadmin that it is in use

Source: Internet
Author: User

1. Use phpmyadmin to modify the TABLE. repair table 'your TABLE name' or directly on the database management interface, select a TABLE, as shown in figure

2. If the modification fails, we can try to stop mysql first when replacing the local mysql database, then copy the table, and then start mysql.

To stop mysql, right-click "my computer" on the desktop. In the pop-up menu, click "manage ", in the displayed "Computer Management" interface, find "services and applications"-"services" on the left, and then find mysql on the right to restart.

3. If the above method still does not work, it may be that the mysql server did not stop during packaging, resulting in data problems. We stopped mysql and then repackaged it, then, the server compresses the file into a zip or rar file, transfers the file to the local parsing, stops the local mysql instance, and then replaces the file. This will make it foolproof.

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.