Surf the DreamJustin Avery

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.

Comments

Be the first to comment

Comments are read before they appear. Your email address is never shown.

    Type to search titles and full text. ↵ opens the full results page.