All:
I am attempting to move a set of db's from Linux (Mysql 4.0.20) to Windows (4.1.6). I have everything running, and I can query tables that are all lower case. However I cannot issue a query on a table that contains uppercase letters. This is the my.ini file: [client] port=3306 [mysqld] port=3306 basedir=C:/Program Files/MySQL/MySQL Server 4.1/ datadir=F:/xxx/ tmpdir=F:\\temp\\ default-character-set=latin1 default-storage-engine=INNODB max_connections=100 query_cache_size=100M table_cache=256 tmp_table_size=103M thread_cache=8 #*** INNODB Specific options *** innodb_data_home_dir=F:/xxx/ innodb_log_group_home_dir=F:/xxx/ innodb_data_file_path=ibdata1:15G:autoextend innodb_log_arch_dir=F:/xxx/ innodb_additional_mem_pool_size=7M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=4M innodb_buffer_pool_size=305M innodb_log_file_size=10M innodb_thread_concurrency=8 #*** MyISAM Specific options myisam_max_sort_file_size=100M myisam_max_extra_sort_file_size=100M myisam_sort_buffer_size=205M key_buffer_size=157M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K #set-variable = lower_case_table_names=2 And this is the error I get if I attempt to access the table Grade Select * from Grade ERROR 1016 (HY000): Can't open file: 'grade.InnoDB' (errno: 1) In the .err log I have: 041111 13:47:03 InnoDB error: Cannot find table tpri/grade from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? Look from section 15.1 of http://www.innodb.com/ibman.html how you can resolve the problem. 041111 13:47:03 [ERROR] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Can't open file: 'grade.InnoDB' (errno: 1) I am pulling my hair out! Please help! Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2278
