Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

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.



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com