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/win32?unsub=lists@pantek.com