|
Blue Forest http://www.lslnet.com at 3:18 p.m. on August 26, 2006
[CD ]MYSQL can not write data into the data table Hello
I just installed Covert 9.0, for the convenience, I MYSQL Based copy of the original data directly to the corresponding MYSQL Based catalog, these documents will be set up as follows : chmod and chown mysql.mysql 660. I
To meet the literacy competence. MYSQL Based customers in the database accordingly and literacy competence, but when I delete the contents of the database, there are mistakes
ERROR 1036 : Table 'xxx' is read only
Why? Please enlighten me master
SIMON
|
The database is MySQL root user landing? |
Unicorn_angel reply to the message, 2nd Floor The database is MySQL root user? = Landing on, I have used the originally designated users too.
Please enlighten me
SIMON |
Chown 777 indicators shown as *.*
Try and |
Unicorn_angel reply to the message, 4th Floor I will read the paper CHMOD 777 is the same database, Read TABLE IS ONLY Why? |
TABLE IS ONLY Read
Table lock
UNLOCK Payroll |
Unicorn_angel reply to the message, 6th Floor Now all of this database, will be used UNLOCK Payroll? I tried, but the problem still exists. Suggest
SIMON |
-->
Tieshanglai integrity of your operation, your problem is how to operate the process in detail. |
Reply to the message, the eighth floor yejr Hello
I just installed Covert 9.0, for the convenience, I MYSQL Based copy of the original data directly to the corresponding MYSQL Based Catalog ((var/lib/mysql), the following documents will be installed :
Chown-R mysql.mysql *
Installed the paper clip into each database
Chmod-R 660 *
To meet the literacy competence.
Then enter MYSQL Based
Mr. GRANT PRIVILEGE TO ALL. . . . .
Adding users to read and write authority.
When the tests, no problem reading each database, but to amend and delete the contents of the table, there are mistakes
ERROR 1036 : Table 'xxx' is read only
I operate the entire process is over
Please enlighten me.
SIMON |
MYSQL Based data not included Who can help me solve the problem, only time can not be changed and added. |
| |