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 (<installdir/share it's a sister folder to your <installdir>/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=lists@pantek.com

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek