List:General Discussion« Previous MessageNext Message »
From:Francisco Reinaldo Date:June 13 2002 2:48pm
Subject:Re: table is read only when DB copied from Win to UNIX
View as plain text  
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 <savage@stripped> 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" <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
> >
> >
> 


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
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