Re: 4 GB limitation on dynamic row format tables

[Ingo Strüwing]

Try to set "myisam_data_pointer_size" to 8 and then all newly created tables should be unlimited as long as you don't specify MAX_ROWS and your operating system allows for big files.

You can convert existing tables by ALTER TABLE xxx MAX_ROWS = 0;
The option clears a possibly existing value for MAX_ROWS.

See reference manual "13.2.5. CREATE TABLE Syntax". Search for AVG_ROW_LENGTH or MAX_ROWS.