ibdata1文件大小是?复制过来后,要检查本机配置文件my.cnf中的ibdata1相关设置 进入mysql,执行show variables like '%innodb%',可以查看当前innodb是否启用及当前的设置
我又重装了个MYSQL 4.1试了下``也不行`` show tables能看到``select就报错``不过和mysql5下报的错不一样了``是`Got error 1 from storage engine``在这两版的err文件里都有`Cannot find table XXXX/classdb 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? See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html how you can resolve the problem.我去上面说的页面看了看也没发现什么有用的信息``这怎么办?
进入mysql,执行show variables like '%innodb%',可以查看当前innodb是否启用及当前的设置
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?
See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
how you can resolve the problem.我去上面说的页面看了看也没发现什么有用的信息``这怎么办?
+---------------------------------+------------------------+
| Variable_name | Value |
+---------------------------------+------------------------+
| have_innodb | YES |
| innodb_additional_mem_pool_size | 3552256 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 173015040 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 2097152 |
| innodb_log_file_size | 87031808 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | .\ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
+---------------------------------+------------------------+
27 rows in set (0.00 sec)配置文件my.cnf中的ibdata1相关设置就是要改上面的变量内容``??
1、 .frm文件所在的文件夹名与原机要相同
2、 将原机的ibdata1文件覆盖本机的ibdata1文件前要先停止本机的mysql服务
刚才在windows下的mysql5.0.51下测试了,没问题
将原来的test库(下面全是innodb表) 与ibdata1复制到 另外机器的mysql5.0.51及5.1.24下都能正常使用注:windows下默认情况ibdata1与建立的数据库文件在同一路径
...
.isd
.myd
.myi它们都干什么的```.ism
.isd
的文件好像不是每个表都有``
MD是版本问题``原库是MYSQL4.0.X下的``