备忘:MySQL InnoDB Error "the table is full"

[size=large]
http://blog.imminentweb.com/technologies/mysql-innodb-error-table-full
----------

http://dev.mysql.com/doc/refman/5.0/en/full-table.html explains some common causes for the error "the table is full" and tells how to fix it.

If you are using MySQL InnoDB, and the file limit isn't reaching the maximum file size limit by the operation system, then check your my.cnf config file, and look for a line like

innodb_data_file_path = ibdata1:10M:autoextend:max:128M

Increase the "max:128M" to something bigger, such as "max:526M".

If you want to increase the innodb_log_file_size, do this:

1. shut down mysqld cleanly
2. remove ib_logfile* files in your mysql data directory, which is possibly /var/lib/mysql

我的路径是
vi /etc/mysql/my.cnf
改为
innodb_data_file_path = ibdata1:10M:autoextend

3. restart mysqld again and check all tables are fine.

[/size]