mysqldump is the preferred backup program for DBAs and MySQL users. Whether because it’s free or because of its ease of use. And also because it has always been distributed with all MySQL installation packages.
Although it is by no means my favorite program or method for making backups, I have to agree that for small databases (up to about 30-50 GB), it can actually surprise me.
Of course, not every surprise is necessarily good. Sometimes restoring 50GB of backup data doesn’t end well.
Now, let me invite you to imagine a scenario. You have your backup strictly up to date. The “txt” file containing your backup holds 50GB of valid SQL commands, mostly INSERTS. Then, the customers table is damaged beyond repair! And you tell me: “No problem, I have a backup!”
Having a backup solves part of the problem. But notice you have 50GB of backup containing all tables of your database. And restoring that backup will take from 3 to 5 hours, depending on many factors.
The question is: Is it rational to restore all tables from all databases contained in your backup instead of only the damaged one? The answer is no!
There are several ways to solve this. One of them is to use alejuice. Alejuice is a simple program written in C that extracts from your mysqldump backup file only the table you need to repair and/or restore.
Its usage is quite simple:alejuice <name of the table to extract> <backup file> <output file>
Below are the binaries available for download:
[download id=”1″][download id=”2″]
Feel free to share ideas and also to report any errors.
Visit our Blog
Learn more about databases
Learn about monitoring with advanced tools
Have questions about our services? Visit our FAQ
Want to see how we’ve helped other companies? Check out what our clients say in these testimonials!
Discover the History of HTI Tecnologia
