Restore single table from HUGE mysqldump file 
Tuesday, November 17, 2009, 11:23 PM - Coding, sydphp
That's one of the problems with 'enterprise' websites - huge databases. Knowing that everything is backed up, it is occasionally tempting to run some ad-hoc handmade 'looks about right' SQL statements every now and then - and occasionally they don't work out too well.

As it happens, restoring a table from a 5GB SQL backup can actually be a pretty time consuming task, not to mention tedious.

Faced with this slightly daunting task I did what I usually do when faced with daunting tasks - checked how other people did it :)

So a big thanks to ThatsLinux for sharing a nice little shell script that takes the pain out of extracting one little table from a mammoth sql script. Kudos.

ThatsLinux

Comments 
Comments are not available for this entry.