List:General Discussion« Previous MessageNext Message »
From:Francisco Reinaldo Date:June 13 2002 8:56pm
Subject:RE: table is read only when DB copied from Win to UNIX
View as plain text  
Hi Gary,

According to this from MySQL manual:

"2.5.5 Upgrading to Another Architecture

If you are using MySQL Version 3.23, you can copy the
`.frm', `.MYI', and `.MYD' files between different
architectures that support the same floating-point
format. (MySQL takes care of any byte-swapping
issues.) 

The MySQL ISAM data and index files (`.ISD' and
`*.ISM', respectively) are architecture-dependent and
in some cases OS-dependent. If you want to move your
applications to another machine that has a different
architecture or OS than your current machine, you
should not try to move a database by simply copying
the files to the other machine. Use mysqldump instead.


By default, mysqldump will create a file full of SQL
statements. You can then transfer the file to the
other machine and feed it as input to the mysql
client. 

Try mysqldump --help to see what options are
available. If you are moving the data to a newer
version of MySQL, you should use mysqldump --opt with
the newer version to get a fast, compact dump. 

The easiest (although not the fastest) way to move a
database between two machines is to run the following
commands on the machine on which the database is
located:"

files are not platform dependent. Just the floating
field is not. I have done it. I can query the
database. It just that the tables are read only.

Thanks again.
--- Gary.Every@stripped wrote:
> The db files are not standard text files, and ARE
> platform dependent. Sorry!
> 
> 
> Gary Every
> Sr. UNIX Administrator
> Ingram Entertainment
> (615) 287-4876
> "Pay It Forward"
> mailto:gary.every@stripped
> http://accessingram.com
> 
> 
> -----Original Message-----
> From: Francisco Reinaldo [mailto:frsgti@stripped]
> 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 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
> 
>
---------------------------------------------------------------------
> 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-thread111859@stripped>
> To unsubscribe, e-mail
>
<mysql-unsubscribe-Gary.Every=ingramentertainment.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
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