Mysql Table is readonly Solution

Mysql Table is readonly solution today, copy the Table of the next mysql Data to another folder. When the result is accessed, the error "Table is readonly" is returned. My host is centos5, Because I encountered many permission problems before. When this prompt is displayed, the first response is that the permission settings of the data table are not affected. After you grant the write permission to an error table file, an error occurs. After google finds that it still needs to be flushed. Use the mysqladmin-u <username>-p flush-tables command to flush all readonly tables. The specific steps to solve mysql table is readonly at www.2cto.com are: add the writable permission to the mysql database directory, that is, execute refresh mysqladmin-u <username>-p flush-tables in the Bin directory from mysql 777 to. In addition, the mysql permission table is changed, you can restart the mysql server mysqladmin-u <username>-p reload. In order to avoid this problem, the mysql Table is readonly (mysql DATA Table read-only) make a summary of the solution to this problem. If you encounter a prompt such as mysql table is readonly (data table read-only), check the cause of the problem from the following five perspectives: 1. Check whether the read-only table file permissions are properly configured. 2. Check whether the read-only table is locked. 3. Check whether the database user has independent access control on the read-only tables of the database. 4. use MySQL optimization or repair operations to repair read-only data tables (I use sqlyog) 5. check whether your read-only table is of the InnoDB type. This type of table cannot be copied. Author's journey