• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MySQL question

Z

Zargon

Lifer
I had a server die this week 🙁

I did a migration on the DB from my workstation, but that install destroyed itself so the sql service wont start

this is apparantly not that uncommon with mysql 5.1+ on Windows

I got it reinstalled on the workstation, but I've lost access to the data file(its still there) and I need it back. It has tons of critical info for work on it.

Anyone have any experience doing this?
 
its work data.

I actually discovered the old tables on a backup I did when I found out the raid array was dying. I did a big drag and drop and got it up thank god. it was a long weekend first though

I ran the mysql migration and it did it to the innodb's and thats what I was stuck with as the mysql install imploded

thank god as it saved me alot of headache
 
I usually use a VM (with snapshots) for development ... but I try to get into a habit of running a dump at least twice a week... for this reason..
 
yeah

this is all inherited crap. started this job 5 months ago, and started auditing major system backups 2 weeks ago. this machine was next on the list 🙄
 
Zargon said:
I had a server die this week 🙁

I did a migration on the DB from my workstation, but that install destroyed itself so the sql service wont start

this is apparantly not that uncommon with mysql 5.1+ on Windows

I got it reinstalled on the workstation, but I've lost access to the data file(its still there) and I need it back. It has tons of critical info for work on it.

Anyone have any experience doing this?
Click to expand...

If the file is still there, why can't you copy it to the data directory of a working install, then command line in and export the whole database?
 
I ended up being able, the inital import wasnt myisam, it was innodb which is apparantly much harder to work with, especially when the logs got nuked.....

but I found a day old backup of the myisam stuff so I dropped it in soI can work with it again


thank god
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top