Contact

E: Peter Davies
P: 0845 310 5320

SocNet's

Blog‎ > ‎

Gentoo default InnoDB max table size

posted 12 May 2009 04:52 by Peter Davies
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.

  Sign in   Recent Site Activity   Terms   Report Abuse   Print page  |  Powered by Google Sites