SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 09:46 AM
| ||||
| ||||
 How to re-attach database after crash Hi, Maybe there's a FAQ here, but I did not find it. So I hope you don't mind me putting my qustion directly in this group. Situation: harddisk crash. Fortunately it was the systemdisk that crashed, so all the data was preserved. I've reinstalled MySQL agin, but now I need to re-attach the tables/ database from E:\Mysql50\F1 to the server. Can anyone tell me how? There's no back-up since this is a experimental server... Thanx in advance! Ron      |
|
02-28-2008, 09:46 AM
| |||
| |||
| Re: How to re-attach database after crash Ron wrote: > Hi, > > Maybe there's a FAQ here, but I did not find it. > So I hope you don't mind me putting my qustion directly in this group. > Situation: harddisk crash. Fortunately it was the systemdisk that > crashed, so all the data was preserved. > I've reinstalled MySQL agin, but now I need to re-attach the tables/ > database from E:\Mysql50\F1 to the server. > Can anyone tell me how? There's no back-up since this is a > experimental server... > > Thanx in advance! > > Ron > Ron, It might be as simple as just going into your my.ini file and changing the datadir to E:\Mysql50\F1. Assuming, of course, you're running the same version of mySQL. Of course you'll have to restart MySQL. -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ================== |
|
02-28-2008, 09:46 AM
| ||||
| ||||
| Re: How to re-attach database after crash Jerry Stuckle wrote: > Ron wrote: >> Hi, >> >> Maybe there's a FAQ here, but I did not find it. >> So I hope you don't mind me putting my qustion directly in this group. >> Situation: harddisk crash. Fortunately it was the systemdisk that >> crashed, so all the data was preserved. >> I've reinstalled MySQL agin, but now I need to re-attach the tables/ >> database from E:\Mysql50\F1 to the server. >> Can anyone tell me how? There's no back-up since this is a >> experimental server... >> >> Thanx in advance! >> >> Ron >> > > Ron, > > It might be as simple as just going into your my.ini file and changing > the datadir to E:\Mysql50\F1. Assuming, of course, you're running the > same version of mySQL. > > Of course you'll have to restart MySQL. > just copy the old data folder's contents to the new data folder, restart mysql and you should be back in business. -- lark -- hamzee@sbcdeglobalspam.net To reply to me directly, delete "despam". |
Linear Mode
