Recently someone contacted me to restore a huge database to their new servers.The database dump file was about 5GB having around 13 millions records.Each row included a huge TEXT field. The new server was a dedicated server from Godaddy. The initial step was not so hard. It is a good practice to disable indexes while importing huge database and when all the rows are done inserting enable the indexes. all the command to do this
Tags: database, filesort, import huge tables, keycache, mysql, repair table
