Don't copy the physical files. Use mysqldump and mysqlimport instead.
Kind Regards, Chris Knipe MegaLAN Corporate 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 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 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 > > --------------------------------------------------------------------- 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
