getting database back after a disaster + no back-ups

Hi,
A strange one here, my windows 2003 server died, but i
have managed to get access to all the drive, i had
mysql 5.0 installed on it. The issue was caused by
incompatible hardware, so 2003 will not go onto the
machine. I've managed to put a partition on + boot
into windows 2000, is there anyway i can get my old
mysql database back?



thanks

Mark


____________________________________________________________ ________________________
Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center.
http://autos.yahoo.com/green_center/

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

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

Mark Mchugh wrote:
> Hi,
> A strange one here, my windows 2003 server died, but i
> have managed to get access to all the drive, i had
> mysql 5.0 installed on it. The issue was caused by
> incompatible hardware, so 2003 will not go onto the
> machine. I've managed to put a partition on + boot
> into windows 2000, is there anyway i can get my old
> mysql database back?
>
>

The only possible way is to somehow restore any lost file after a
re-partition. However, from my personal experience, once you wipe out
the partition any chance you had to undelete the old files are *gone*.
On top of that, after you repartitioned your drive, you had to format it
again in order to install Windows 2000.

I am not a forensics specialist but I would put your odds a recovering
any files from your previous setup at practically zero.

--
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /
/ /|_/ / // /\ \/ /_/ / /__
/_/ /_/\_, /___/\___\_\___/
<___/
Join the Quality Contribution Program Today!
http://dev.mysql.com/qualitycontribution.html


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

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

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?



--- Shawn Green wrote:

> Mark Mchugh wrote:
> > Hi,
> > A strange one here, my windows 2003 server died,
> but i
> > have managed to get access to all the drive, i had
> > mysql 5.0 installed on it. The issue was caused by
> > incompatible hardware, so 2003 will not go onto
> the
> > machine. I've managed to put a partition on +
> boot
> > into windows 2000, is there anyway i can get my
> old
> > mysql database back?
> >
> >
>
> The only possible way is to somehow restore any lost
> file after a
> re-partition. However, from my personal experience,
> once you wipe out
> the partition any chance you had to undelete the old
> files are *gone*.
> On top of that, after you repartitioned your drive,
> you had to format it
> again in order to install Windows 2000.
>
> I am not a forensics specialist but I would put your
> odds a recovering
> any files from your previous setup at practically
> zero.
>
> --
> Shawn Green, Support Engineer
> MySQL Inc., USA, www.mysql.com
> Office: Blountville, TN
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ /
> / /|_/ / // /\ \/ /_/ / /__
> /_/ /_/\_, /___/\___\_\___/
> <___/
> Join the Quality Contribution Program Today!
> http://dev.mysql.com/qualitycontribution.html
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com
>
>




____________________________________________________________ ________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

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

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?
>
>
Well, you are in a totally different situation than I thought you were!
Yes, your database should be intact. In fact, you may be able to use it
where it sits. However, for safety's sake, please copy it somewhere safe
while you have the chance. Remember to backup your data files, your log
files, your binaries, your "share" folder ( sister folder to your /bin folder where your binaries
reside), and your config file (win.ini) in order to have a full snapshot
of your installation.

Yes, you can copy your old files to the new drive. If you preserve their
"relative locations" when you move them to your new volume (assuming you
are wanting to get rid of the other partition) you won't have anything
in your win.ini to edit. Otherwise you may need to change your basedir,
datadir, and/or other settings to match the new environment.

--
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /
/ /|_/ / // /\ \/ /_/ / /__
/_/ /_/\_, /___/\___\_\___/
<___/
Join the Quality Contribution Program Today!
http://dev.mysql.com/qualitycontribution.html


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

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

OOPS!! I made a typo!!

Shawn Green wrote:
>
> Well, you are in a totally different situation than I thought you
> were! Yes, your database should be intact. In fact, you may be able to
> use it where it sits. However, for safety's sake, please copy it
> somewhere safe while you have the chance. Remember to backup your data
> files, your log files, your binaries, your "share" folder
> (/bin
> folder where your binaries reside), and your config file (win.ini) in
> order to have a full snapshot of your installation.

Your config file is actually called "my.ini" by default.

--
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /
/ /|_/ / // /\ \/ /_/ / /__
/_/ /_/\_, /___/\___\_\___/
<___/
Join the Quality Contribution Program Today!
http://dev.mysql.com/qualitycontribution.html


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

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=gcdmw-win32@m.gmane.org

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

Others may be able to advise you better, but assuming your MySQL data
folder is intact, I would just copy that safely somewhere else, install
the same version of MySQL, then copy the contents of the saved data
folder into the data folder created by the new install. I think you may
find you have everthing back again.

John Bonnett

-----Original Message-----
From: Mark Mchugh [mailto:mark_mch@yahoo.com]=20
Sent: Monday, 27 August 2007 10:45 PM
To: mysql list
Subject: getting database back after a disaster + no back-ups

Hi,
A strange one here, my windows 2003 server died, but i have managed to
get access to all the drive, i had mysql 5.0 installed on it. The issue
was caused by incompatible hardware, so 2003 will not go onto the
machine. I've managed to put a partition on + boot into windows 2000,
is there anyway i can get my old mysql database back?



thanks

Mark


=20
____________________________________________________________ ____________
____________
Park yourself in front of a world of choices in alternative vehicles.
Visit the Yahoo! Auto Green Center.
http://autos.yahoo.com/green_center/=20


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

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

Hi Mark

Shawn reply is right way... but its bit difficult to recover...
I was faced the same problem when I was trying to install Linux; My OS
corrupted, so I found the way just install the windows 2000 or XP and get
the software named "GetDataBack for NTFS" (hope you used NTFS file system).

Using NFS GetDataBack software you can recover all files. once you recovered
the files just create new db as same name and paste the file inside the
mysql data folder ( I mean inside the dbname folder)...

I explained here the way I succeed my problem. Let me know if you need more
details.


Thanks
Muthukumar Selvarasu
Project Manager.
Webmasters.


-----Original Message-----
From: Shawn Green [mailto:shawn@mysql.com]
Sent: Tuesday, August 28, 2007 1:56 AM
To: Mark Mchugh
Cc: mysql list
Subject: Re: getting database back after a disaster + no back-ups

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?
>
>
Well, you are in a totally different situation than I thought you were!
Yes, your database should be intact. In fact, you may be able to use it
where it sits. However, for safety's sake, please copy it somewhere safe
while you have the chance. Remember to backup your data files, your log
files, your binaries, your "share" folder ( sister folder to your /bin folder where your binaries
reside), and your config file (win.ini) in order to have a full snapshot
of your installation.

Yes, you can copy your old files to the new drive. If you preserve their
"relative locations" when you move them to your new volume (assuming you
are wanting to get rid of the other partition) you won't have anything
in your win.ini to edit. Otherwise you may need to change your basedir,
datadir, and/or other settings to match the new environment.

--
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /
/ /|_/ / // /\ \/ /_/ / /__
/_/ /_/\_, /___/\___\_\___/
<___/
Join the Quality Contribution Program Today!
http://dev.mysql.com/qualitycontribution.html


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=muthukumar_se@hotmail.com



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org