How screwed am I?

Pope Viper

Well-known member
My server decided to take a shat. I've got the MySQLData directory, however, when I move the files into the new data directory, they're not being recognized.

Help!
 

Slavik

XenForo moderator
Staff member
My server decided to take a shat. I've got the MySQLData directory, however, when I move the files into the new data directory, they're not being recognized.

Help!
Have you defined the data directories correctly?
 

Pope Viper

Well-known member
To be honest, I'm at the point where I'd let someone remote my server to help me out.

Trusted someone of course.
 

alegeek

Member
I haven't used MySQL on windows for sometime but I assume you've changed the datadir in your my.ini file?
 

Slavik

XenForo moderator
Staff member
Sounds like you may need a specialist to take a look honestly.

The files you have

Are they a) just copied files from when mysql was running?

or b) Recovered files from the knackered server?
 

digitalpoint

Well-known member
Definitely what Slavik said... especially when dealing with InnoDB log files (which you most definitely need if you are dealing with InnoDB tables).
 

Mike Edge

Well-known member
  1. So am I beyond recovery?
Nope, first stop your MySQL server daemon. Then copy over your files. Next change the files ownership to mysql:mysql more then likely they will currently be root:root. Lastly restart Mysql server and all should be fine.
 

Pope Viper

Well-known member
Still killing me.

Would it be possible for one of you guys to take my various databases, and do SQL dumps of them?
 
Top