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. --- [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > http://accessingram.com > > > -----Original Message----- > From: Francisco Reinaldo [mailto:[EMAIL PROTECTED]] > 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 <[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 > __________________________________________________ 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
