import

Fixing MySQL 'The table is full' error using the official MySQL Docker image

Recently I had to test importing some very large databases with lots of giant log tables (e.g. 5+ GB tables), and when I tried doing an import into a local docker MySQL container instance, I got ERROR 1114: The table is full. Here are the commands I used:

# Run a MySQL container locally to test a large file import.
$ docker run --name mysql-import-test -p 3306 -e MYSQL_ROOT_PASSWORD=root -e MYSQL_DATABASE=database_name -d mysql:latest

# Import a database .sql file and monitor progress with pv.
$ pv ~/database.sql | mysql -u root -proot -h 127.0.0.1 --port 32774 database_name
ERROR 1114 (HY000) at line 93898: The table 'xyz' is full

I found that—likely due to some Docker filesystem defaults—the MySQL import would fail every time when there was a database table containing more than 1GB of data. Now, this could be related to the way the database was exported, and I also found some issues where people were using memory tables that got exported and wouldn't import cleanly.

Importing HDV footage from Sony HDV Cameras into iMovie '11 (or '08/'09)

I have had a ton of trouble today getting a rented Sony HVR-Z1U HDV Camera to work with iMovie '11 - I was having trouble both importing pre-recorded footage (in VCR mode) and importing live footage (in Camera mode). QuickTime Player would allow me to import video from the camera at DV quality, but I couldn't get HD.

I found that the camera was downconverting the video to regular DV (squeezing the pixels so it would still be a 16:9 widescreen picture) when using the i.Link (FireWire/IEEE 1394) port. After trying out a variety of settings, I was finally able to set up the camera so it would import (both in VCR and in Camera mode) HD video, directly into iMovie '11.

You simply need to set the following settings in the camera's menu:

Subscribe to import