1

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?

pkaramol
  • 213
  • 1
  • 4
  • 9

2 Answers2

1

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; (and SET FOREIGN_KEY_CHECKS=1; afterwards). This will speed up your import (though by how much is hard to tell).

Glorfindel
  • 2,205
  • 5
  • 19
  • 26
0

For large-scale backup and restore, a physical backup is more appropriate, to copy the data files in their original format that can be restored quickly, and recommends the MySQL Enterprise mysqlbackup utility. -- http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#mysqldump-performance

Find Detailed Answer here: https://forums.mysql.com/read.php?24,645437,645443#msg-645443