see : http://www.mysql.com/doc/U/p/Upgrading-to-arch.html
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.) 2 pcs x86 1under windows xp the other under linux mandrake. I have near 50 database or more, the copy of the datadir is the best solution. As i tell I can select ... Butr no inserting ! see my Error: 1036 - Table country is read. If you have a cool solution my 2 mysqld (zindows and linux) are on the same lan ! Thanks. > You should use mysqldump[.exe] to export/import, on the respective systems: > > 4.8.5 mysqldump, Dumping Table Structure and Data > http://www.mysql.com/doc/m/y/mysqldump.html > > C:1 > >>>>>>>>>>>>>>>> > > Hi all, > > I developp a site with some mysql table which are files myd myi n frm under > windows x86 arch. > I copy my table into a liinux box x86 arch too. > > Bu when trying to modidy tables I get an Error: 1036 - Table country is read > only > > I manage the rigth of new created tables. > I get things like that that I report to my read only tables : > > 12 -rw-rw---- 1 mysql mysql 8674 jui 15 2001 country.frm > 24 -rw-rw---- 1 mysql mysql 20516 jui 15 2001 country.MYD > 4 -rw-rw---- 1 mysql mysql 1024 jui 15 2001 country.MYI > 12 -rw-rw---- 1 mysql mysql 8564 mar 9 23:18 TableName.frm > 0 -rw-rw---- 1 mysql mysql 0 mar 9 23:18 TableName.MYD > 4 -rw-rw---- 1 mysql mysql 1024 mar 9 23:18 TableName.MYI > > I make a chown -R mysql.mysql * > n chmod 660 * > > > > Nothing change. > > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.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 > > --------------------------------------------------------------------- > 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!? Get your free @yahoo.com address at http://mail.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