Seeding large data

[thammer67]

I am able to seed initial data for specific tables using an INSERT statement with one or many VALUES and that works great. When I try to do the same for a table with 41,000 records I get the following:

Applying: 20250625151312_create_table_mytable.sql
Applied: 20250625151312_create_table_mytable.sql in 33.659666ms
Error: invalid connection

The database server is running fine and I see no other errors. 'dbmate status' shows the migration did not apply.
Anybody have any idea how to seed large amounts of data?

[dossy]

What database software? And, how many bytes large is the migration file?

Try splitting up the data into multiple INSERT statements with fewer VALUES clauses.

You may need to split up the data into multiple migration files.