Gentoo default InnoDB max table size

Written by Peter Davies on 12 May 2009.

Whilst importing a 3Gb Magento database into a development area the MySQL import failed stating: "The table is full".

A little investigation found that the InnoDB table sizes are defined as 10Mb with a 128Mb limit by default in Gentoo. To rectify this simply modify the:

nano /etc/mysql/my.cnf

Locate the:

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

And edit to suite your needs:

innodb_data_file_path = ibdata1:10M:autoextend

The data import then should work ok.