Hello. I am trying to set up a MySQL database shared between SuSE 9.1 and a Win XP (both 4.0.18 from binary). The database resides on a FAT32 partiton accessible from both OS's. I am able to access the database transparently from Win XP by modifying my.cfg as described in the manual.
The procedure does not work on Linux, unfortunately. After having modified /etc/my.cnf like this: ------------- # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 datadir = /windows/E/data/ socket = /var/lib/mysql/mysql.sock -------- and copying the files from /var/lib/mysql to /windows/E/data/ I can access the database (as root in mysql) but not individual tables. The database was created in windows. I get the error: mysql> describe ne_ns_ft; ERROR 1017: Can't find file: 'ne_ns_ft.MYI' (errno: 2) The file is there of course. I can create new tables and access them normally. The new table-files have permissions identical to the "old" ones. -rwxrwx--x 1 mysql users 8554 2004-10-20 17:41 test.frm -rwxrwx--x 1 mysql users 0 2004-10-20 17:41 test.MYD -rwxrwx--x 1 mysql users 1024 2004-10-20 17:41 test.MYI If I copy the database directory to /var/lib/mysql (and change the my.cnf back) I have the same problem but with a new error: mysql> use exp041012 Database changed mysql> select * from ne_as_10; ERROR 1017: Can't find file: './exp041012/ne_as_10.frm' (errno: 13) The file is there of course. I would appreciate input to solve the problem, or suggestions on alternative ways to achive the aim of accessing the same (or synchronized) data from Linux/Windows. Regards, Lau Sennels -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
