---
title: "Gentoo default InnoDB max table size"
date: "2009-05-12"
modified: "2013-03-04"
path: "/37-gentoo-default-innodb-max-table-size.html"
section: "/ramblings"
aliases:
  - "/37"
  - "/37-gentoo-default-innodb-max-table-size"
  - "/37.html"
  - "/ramblings/37-gentoo-default-innodb-max-table-size.html"
---

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.