List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:June 12 2002 11:08pm
Subject:Re: table is read only when DB copied from Win to UNIX
View as plain text  
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" <frsgti@stripped>
To: "Tonu Samuel" <tonu@stripped>
Cc: "MySQL" <mysql@stripped>
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
> <tonu@stripped> 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
> > <mysql-thread111732@stripped>
> > To unsubscribe, e-mail
> > <mysql-unsubscribe-frsgti=yahoo.com@stripped>
> > 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 <mysql-thread111793@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-savage=savage.za.org@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
table is read only when DB copied from Win to UNIXFrancisco Reinaldo12 Jun
  • Re: table is read only when DB copied from Win to UNIXTonu Samuel12 Jun
    • Re: table is read only when DB copied from Win to UNIXFrancisco Reinaldo13 Jun
      • Re: table is read only when DB copied from Win to UNIXChris Knipe13 Jun
        • Re: table is read only when DB copied from Win to UNIXFrancisco Reinaldo13 Jun
          • Innodb Memory use for a Benchmark...Rogger13 Jun
            • Innodb Memory use for a Benchmark in MySQL...Rogger13 Jun
RE: table is read only when DB copied from Win to UNIXFrancisco Reinaldo13 Jun