Thanks for the tip but I have added to the table db in mysql database full permission for everybody to that database. I don't think that is a permission thing because when I add a new table, I can insert data into that new table. Besides it does not happen when I copy the database from UNIX to Windows.
I'll keep trying though but if somebody already knows the solution, please let me know. Thanks. --- Tonu Samuel <[EMAIL PROTECTED]> wrote: > > > On Wed, 12 Jun 2002, Francisco Reinaldo wrote: > > > Fine, I can see the database, show tables works, > > selects works. The whole nine yards? Nope! I > cannot > > insert any values in that database. I get the > > following error: "Table xxx is read only". I have > > checked the OS permission for that directory and I > > have given full persmission (write, read and > execute). > > Also I have checked MySQL permissions, adding full > > permission for all users to that database but > nothing. > > It looks like the problem is at the table level > > because when I manually add a new table to the > MySQL > > UNIX, the inserts work. > > The only reason this can happen is wring permission > bits no tables. > Internally there is no way to make MyISAM (I assume > you use them) > read-only. Look as which user mysqld runs and make > tables writable to that > user. > > Tonu > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php