1. Home >
  2. Apps >
  3. Groups >

Speed up import of mysql database with this simple trick

Question asked by Kaustubh Katdare in #Databases on Feb 4, 2018
Kaustubh Katdare
Kaustubh Katdare · Feb 4, 2018
Rank A1 - PRO
I was doing a trial run of importing a moderately big database on my local machine and it was taking almost forever. I found out this tip by someone that worked like charm. Try this out

mysql> use db_name;

mysql> SET autocommit=0 ; source the_sql_file.sql ; COMMIT ;
It not only showed me what's happening, but also did a world of difference to the speed of import!

PS: I'm not into databases and not sure what magic does autocommit=0 does. Would love if someone can explain in easy to understand words. Posted in: #Databases
Ramani Aswath
Ramani Aswath · Feb 4, 2018
Rank A1 - PRO
It is very simple. To me autocommit = 0 means I know damn all about it. The only database Software I ever used was the ancient dbase II.
Kaustubh Katdare
Kaustubh Katdare · Feb 4, 2018
Rank A1 - PRO
Only had heard about the dBase II. Looks like they share similar syntax.

You must log-in or sign-up to reply to this post.

Click to Log-In or Sign-Up