Go Back   PCMech Forums > Help & Discussion > Internet, Web Applications, & The Cloud

Need Some Help? Type Your Keywords Here:

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
Old 02-06-2008, 10:06 PM   #1
Member (10 bit)
 
Kareeser's Avatar
 
Join Date: Mar 2006
Location: Toronto, Canada
Posts: 810
Salvaging MySQL Database...

Hey guys..

So my server ended up dying for no reason. I think the hard drive died.

In any case, if it's only a booting error or something, then technically I can still recover the files on it.

Would it be possible to recreate my database this way? If so, where in the HD would I go about recovering these files?

Thanks!
Kareeser is offline   Reply With Quote
Old 02-07-2008, 06:32 AM   #2
Ride 'em Cowboy
 
EzyStvy's Avatar
 
Join Date: Dec 1999
Location: Dallas, Tx
Posts: 9,018
Bit of a guess here...The raw data files will probably be in a folder called DATA. Possibly under a folder called MYSQL. (C:\program files\mysql\data)

They will probably be .MDF and .LDF file types.

Once you get the machine back up n running, am also guessing you will have to run an "attach" command from a command prompt to attach them to the sqlmgr....
__________________
Stand Up 2 Cancer - SU2C
EzyStvy is offline   Reply With Quote
Old 02-07-2008, 07:58 AM   #3
Staff
Premium Member
 
mairving's Avatar
 
Join Date: Jul 1999
Location: Arlington, TN
Posts: 5,538
Is it Windows of Linux?
__________________

Want to Make $$$$ with your Computer? No Risk! Simply press shift-4 four times in a row
mairving is offline   Reply With Quote
Old 02-08-2008, 06:54 PM   #4
Member (10 bit)
 
Kareeser's Avatar
 
Join Date: Mar 2006
Location: Toronto, Canada
Posts: 810
Thanks, Ezy, Mariving,

It's a Windows Machine.

Theoretically, however, if the replacement machine (or rather, replacement hard drive) is Linux, would there be any problems?
Kareeser is offline   Reply With Quote
Reply

Bookmarks

Still Need Help? Type Your Keywords Here:


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Computer Acronyms Floppyman Computer Hardware 156 06-18-2006 07:25 AM
Retrieve Password from MYSQL Database? salchipapi Web Design / Development 3 10-12-2005 10:07 AM
populating an html table from a mysql database Designer Web Design / Development 2 08-08-2005 06:57 AM
MySQL and Visual Studio.NET shartken Web Design / Development 1 11-01-2004 09:56 PM
Unrecognised Database Format skeletonkeys Web Design / Development 4 09-25-2002 12:16 PM


All times are GMT -5. The time now is 06:33 AM.
Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.6.0