Categories
Snippets

Restoring mySQL database from the file system MT

When you get a flat backup of your server the SQL is useless to you. Unless you’ve run SQL exports and backups your self you’re going to have to recover the databases from these flat unusable files.

Fortunately there’s a tool in the Media Temple back end that allows for this. Simple connect to the server via SSH and run the following command

/usr/local/mt/bin/mib --restoredbs --apply

Note that this doesn’t need to be run from your /old/ section of the site, the command relies on the current working system. You will then be prompted to go with either /restore or /old, and then choose the database you want to restore. I’m not sure if you can restore all of them at once, I tried a comma separated list and it failed so ended up doing one at a time.

Leave a Reply

Your email address will not be published. Required fields are marked *