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
-----Original Message-----
From: David yahoo [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 09, 2002 2:22 PM
To: [EMAIL PROTECTED]
Subject: mysql from windows to linux
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
