|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
#1 |
|
Member (10 bit)
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! |
|
|
|
|
|
#2 |
|
Ride 'em Cowboy
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 |
|
|
|
|
|
#3 |
|
Staff
Premium Member
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 |
|
|
|
|
|
#4 |
|
Member (10 bit)
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? |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
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 |