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:[email protected]] 
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/[email protected]



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