Database, MySQL

MySQL: Import Large SQL File

Assalamualaikum / Hi,

Today, I just accidentally drop a database with size of about 2GB. To load it back to database gonna took long hours.

So, I have a friend reminded me how to make it faster. Following are the steps taken:

The commands basically to disable few MySQL autocommit, unique_checks and foreign_key_checks.

This will significantly speed up the import process.

I have reduced from about 2 hours plus to 15 minutes.

Hopes that help everyone having the same issue with me.

Thanks,
Nasrul Hazim

Leave a Reply

Your email address will not be published. Required fields are marked *

7 − 1 =