Mysql import timing out

apps

#1

I’m migrating a phpBB forum from another host. The dump from the DB is 115mb. I’ve got it as a file on dreamhost and I am trying to perform an import from the command line within mysql. It runs for a bit then errors out saying my SQL command took longer than 30 seconds to perform.

Is there any way to temporarily disable this 30 second timeout on the DB? The other option would be to run some kind of script that iterates through my dump file and executes each insert individually… Any advice on either of these approaches would be greatly appreciated.

Appreciatively,

Seth

www.skatersforpublicskateparks.org


#2

bigdump is an excellent script for breaking up large sql imports.

it is available here:
http://www.ozerov.de/bigdump.php