Restoring MySQL dumps

---

Now you've automated the running of MySQL backups with our wonderful solution [:-)]....

But now... you need to restore a specifical database from an entire mysqldump.sql file.

This solution is a bit tricky, but it's simple and uses standard commands.

First let's say we need to restore the database MyDbLost and it is in the middle of the dump file. You don't know where it is so... you need first a few variables.

With

you'll get the number of lines of the file. The output should look like:

Write down the 33815 number. Then you have to identify where your MyDbLost begins:

And you get another line number:

If you don't get any result please try the following:

Now it's time to calc the lines you have to throw away from the head of your file:

33815 - 5913  + 10 = 27912

(the 10 more lines are necessary to get a little "air" between cuts)

then you can type in:

and you will get a new file called mysqldump.1.sql which starts approximately with the declarations of your database.

Now you have to trim out the queue of your file. You must identify where a new database starts:

you'll get an output similar to:

Take the number of lines in which is specified the second database and type

With a little edit on mysqldump.2.sql you'll have exactly what you're looking for: the MyDbLost schema and datas!