MySQL Restore Test

| | Comments (0) |

Your blogs are safely backed up every day (and now I know for sure.) Finally got around to verifying that the daily backups using AutoMySQLDump can be used to restore the entire database. I ran a mini disaster recovery using the old iMac.

Note to self: Kept trying to use the command "mysqldump" to restore, but that is an output only command. Just using "mysql" and reversing the out character > with the in character < did it:

root# /usr/local/bin/mysql -umxxxxx -pgxxxxx mov_type < /2004-10-17.Sunday.sql

(User and password masked.)


Categories

Leave a comment

About this Entry

This page contains a single entry by Jeb published on October 17, 2004 10:25 AM.

Cell Phone Jammers was the previous entry in this blog.

Nose Fairy is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Powered by Movable Type 4.31-en

Good Reads

Flickr Badge

www.flickr.com
This is a Flickr badge showing items in a set called Wallet. Make your own badge here.