Mauricio, have you used upper case letters in table names? What does mysqld print to the .err log?
Please observe the following: http://dev.mysql.com/doc/mysql/en/Moving.html " On Windows, InnoDB internally always stores database and table names in lowercase. To move databases in a binary format from Unix to Windows or from Windows to Unix, you should have all table and database names in lowercase. A convenient way to accomplish this on Unix is to add the following line to the [mysqld] section of your `my.cnf' before you start creating your databases and tables: [mysqld] set-variable = lower_case_table_names=1 On Windows, lower_case_table_names is set to 1 by default. " Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Mauricio Bruns" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, July 13, 2004 8:47 PM Subject: Moving InnoDB database from Linux to Windows > How can I copy the data directory from linux to windows, with the same > mysql version (4.0.16) in both OS and innodb tables? > I try simple copy all files (iblogs, ibdata, mysql dir, database dir) > but I get this error when open a table: > ERROR 1016: Can't open file: 'advogado.InnoDB'. (errno: 1) > > > -- > Mauricio Bruns - ASV Consultoria > > [EMAIL PROTECTED] - www.asv.com.br > Rua Felipe Schmidt, 31 - Sala 904 > 88350-075 - Brusque - SC - Brasil > tel/fax: (47) 351-3901 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
