Ddev database import - dealing with ERROR 1114 (HY000) Table is full

Joeri Poesen //

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/