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
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.