Hi, I have an installation of MySQL in Windows and another one in UNIX Solaris 2.7. I need to move the databases across system and I have manually ftped a database directory from the Windows MySQL to the UNIX MySQL.
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 funny thing is when I do it the other way around, that is, from Solaris to UNIX works without having to do anything at all. Lovely and reliable UNIX!!! Thanks in advance. :-) __________________________________________________ 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