Re: getting database back after a disaster + no back-ups

At 08:35 AM 8/27/2007, Mark Mchugh wrote:
>i had 2 partitions on it before, i can see all the
>files now, but the 2003 partition cant boot and never
>will.... i can see the old data folders + files etc,
>but i presume i can just copy these over to a new
>install?
>

Yes, you can copy the MySQL data directory to another data directory on 
another machine. The name of the directory is the name of the database. 
This data directory contains the files: *.frm (table definition), *.blb 
(blob/memo), *.myd (data), and *.myi (index). If you are using InnoDb then 
you need to copy its filespace to the new drive.

These 3 words will save your bacon:  backup, backup and backup. I like 
Acronis backup for Windows because it is fast and ultra-reliable and runs 
automatically. It backs up the data to another drive, usually a removable 
drive so you have offsite backup. I'm sure your boss would be more than 
willing to splurge for it now.

Mike

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]