RE: table is read only when DB copied from Win to UNIX

2002-06-13 Thread Francisco Reinaldo
CTED]] > Sent: Thursday, June 13, 2002 9:48 AM > To: Chris Knipe > Cc: MySQL > Subject: Re: table is read only when DB copied from > Win to UNIX > > > Thanks a lot Chris for the tip, but that precisely > what I am trying to avoid so my users don't

Re: table is read only when DB copied from Win to UNIX

2002-06-13 Thread Francisco Reinaldo
rporate Networking Services > Tel: +27 21 854 7064 > Cell: +27 72 434 7582 > > - Original Message - > From: "Francisco Reinaldo" <[EMAIL PROTECTED]> > To: "Tonu Samuel" > <[EMAIL PROTECTED]> > Cc: "MySQL" <[EMAIL P

Re: table is read only when DB copied from Win to UNIX

2002-06-12 Thread Chris Knipe
Samuel" <[EMAIL PROTECTED]> Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 12:14 AM Subject: Re: table is read only when DB copied from Win to UNIX > Thanks for the tip but I have added to the table db in > mysql database full permission for everybody t

Re: table is read only when DB copied from Win to UNIX

2002-06-12 Thread Francisco Reinaldo
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 Win

table is read only when DB copied from Win to UNIX

2002-06-12 Thread Francisco Reinaldo
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 y

Re: table is read only when DB copied from Win to UNIX

2002-06-12 Thread Tonu Samuel
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 direct

table is read only when DB copied from Win to UNIX

2002-06-12 Thread Francisco Reinaldo
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 y