Restore requests are common and so are the restores of specific
entities: a database, or one or more table(s). This has been
discussed a lot and we have plenty of tools and solutions already
In this blog post we will cover an interesting solution that I came across when I received a restoration request from a client with a specific scenario.
The scenario? Well, the client was on a Windows server with 400GB of mysqldump and wanted to restore a table.
As Linux players we already know of some tools and techniques to export a table or database from mysqldump – for example, using sed command or using the script mysqldumpsplitter (based on sed itself). But on Windows we are powerless by not being able to use sed (we’re sad without sed.) Also, there was no cygwin to ease up the pain.
We had to come-up with a solution that works on …[Read more]