Thanks a lot Chris for the tip, but that precisely what I am trying to avoid so my users don't have to go through import and exports. I am kind of lazy too and I don't want to create an application to do that :-).
Wouldn't be nice that we could just copy the database, modify permissions and go? Come on! I bet that somebody has already done it. Please tell me... Thanks. --- Chris Knipe <[EMAIL PROTECTED]> wrote: > 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 > > > > > __________________________________________________ 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