I have an SQL file that I want to import in a migration. It is data
that will never change and must always be in the database for the
application (if you must know, it is a database of about 140,000
cities in the U.S.).
Originally, I did this:
mysql -u root
So then I thought this would work in my migration:
execute ‘source db/migrate/initial.db’
I assumed that I would need db/migrate because it always says
"Migrating (in /home/michael/app). Well, anyway, I ran the migration
and every time it just errors out after like the 37,000th record is
entered. Is there any limits or anything imposed on execute() that may
be causing the SQL query to be interrupted? Can I override this?