Big Dump

Entry posted by Moonlapse February 11, 2006

304 views

Sounds pretty sick, right? Actually, BigDump is a staggered MySQL dump importing script. Anyone who has loaded a large database backup, transported a large database to a new host, or made a mirror test database knows how challenging it can sometimes be if you administrate remotely without using shell access.

Fortunately, this script makes it a complete snap. Instead of breaking the SQL file into chunks that wouldn't cause a PHP timeout, then loading each one manually, I let this thing run while I went to work. 220MB later, the databse was loaded without a snag. A big thanks goes to Alexey Ozerov for writing such an awesome, time saving tool.