I want to import a couple of huge .sql
dumps (~600G each) into a mysql server 5.5 running on an Ubuntu 14.04.
The machine has about 8G of RAM allocated to it;
The previous machine had 128G;
Storage space considerations aside, what else should I take into account before performing the mysql import command?
Best Answer
If your database tables have them, it's always best to drop indices and recreate them after the import. Also, disable foreign keys temporarily by executing
SET FOREIGN_KEY_CHECKS=0;
(andSET FOREIGN_KEY_CHECKS=1;
afterwards). This will speed up your import (though by how much is hard to tell).