On 04/01/2007 09:06 AM, Jonathan Horne wrote:
i have a production system running FreeBSD 6.2-p3/MySQL 5.0.33, with 2
databases. i also have a development box, which is pretty much a mirror of my
production system, that i would like to import my databases into. daily, the
production system dumps the databases to .sql files, as well as is also backed
up by a netbackup server to tape (entire filesystem is backed up. right now
the dev system has had no databases created in it.
is it possible to restore from tape, the /var/db/mysql directory from the
production into the dev system (ie, and would it start and load those
databases?) or, is really the only viable way to migrate or restore a
database, is to create the blank database, and then reload the dump?
In short, yes, both methods are possible. Although you have to realize
that not all the data is in the data files all the time, nor is it
necessarily in a consistent state, so to maintain a backup using these
files, you will need to shut down the database server to ensure that all
the data/changes have been written to these files from memory and cache.
This can pose a problem in a production system for obvious reasons.
For this reason I backup using a SQL dump, you just need to lock the
tables and go. It compresses nicely too.
-Micah
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
