Mysql Tableisreadonly solution Readonly
BitsCN.com
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 mysqladmin-u After the-p flush-tables command successfully flush all readonly tables, the problem is solved. The specific steps to solve mysql table is readonly are: Add write permission to the mysql database Directory, that is, execute refresh mysqladmin-u from 777 to the mysql Bin directory. -P flush-tables: you can restart the mysql server mysqladmin-u after changing the mysql permission table. -P reload: in order to avoid the problem of this kind of problem, we will summarize the solution to the problem of mysql Table is readonly (mysql data Table read-only. 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 path: bitsCN.com
