Ddev database import - dealing with ERROR 1114 (HY000) Table is full
When you're importing a large database into a new Drupal development environment using ddev, you might encounter the following error:
ERROR 1114 (HY000) at line 19805: The table 'field_revision_field_myfield' is full
Failed to import database for myproject:
Failed to run docker-compose
[-f /home/jpoesen/projects/myproject.test/.ddev/docker-compose.yaml exec -T db
bash -c mysql --database=mysql -e 'DROP DATABASE IF EXISTS db; CREATE DATABASE db;
There are many, many possible causes for this error.
In my case: low disk space prevented the database volume in the ddev's database container from growing to the required size.
I didn't immediately think of this because I would have expected MySQL to display an error like
no space left on device
or something similar.
I wrongly assumed ddev was the culprit and spent a good number of hours looking in the wrong direction.
Just free up disk space, run the db import command again, and all's well again. \o/