The mysql packaging table prompts in phpmyadmin that it is in use. _ MySQL

Mysql packaging table prompts in phpmyadmin that it is in use. phpmyadmin

BitsCN.com

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.

The original tutorial on this site is reproduced with the source: www.111cn.net. Otherwise, the consequences will be borne by you.

Articles you may be interested in reasonably use the load data infile in mysql to import data mysql mysqlhotcopy backup instructions mysql tips: illegal mix of collations for operation 'Union 'detailed description of how to use the count function in mysql: mysql5.5 prompt Deprecated: mysql_query (): the mysql extension is deprecatedmysql lock tables and unlock tables (lock table/unlock) summary: mysql cannot be used to import data to the storage process. mysql prompts [Warning] Cant create test file xxx lower-testmysql to connect to the database after reinstalling mysql. error 1045: MySQL uses utf8 SQL files with garbled characters. mysql mysqldump parameter usage instructions for creating mysql Table partitions using learning notes bitsCN.com