求救mysql error:the table is full
各位高手,小弟在往mysql中导入数据的时候遇到这样一个错误error:the table is full,我查看mysql打印出来的error:
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
091124 21:41:24 InnoDB: Encountered a problem with file .\ibdata3
091124 21:41:24 InnoDB: Disk is full. Try to clean the disk to free space.
091124 21:41:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
091124 21:41:43 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2 user: 'root'
我的mysql安装在C盘,datadir在D盘,C盘还有的空间是10.23G,D盘的空间还有27G。我在网上搜索两个解决(1、修改innodb_data_file_path的设置;2、修改
tmp_table_size )都还是出现同样的错误
我实在不明白为什么会出现这样的错误,期待高手给解答,小弟不胜感激~!