1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How screwed am I?

Discussion in 'Off Topic' started by Pope Viper, Jul 8, 2013.

  1. Pope Viper

    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!
     
  2. alegeek

    alegeek Member

    Made sure you retained the ownerships when moving the files? They need to be owned by MySQL.
     
  3. Slavik

    Slavik XenForo Moderator Staff Member

    Have you defined the data directories correctly?
     
  4. Pope Viper

    Pope Viper Well-Known Member

    I believe so.

    I'm running Windows 2008 R2
     
  5. Pope Viper

    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.
     
  6. alegeek

    alegeek Member

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

    Pope Viper Well-Known Member

    Yep, tried copying files into directory, as well
     
  8. Slavik

    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?
     
  9. Pope Viper

    Pope Viper Well-Known Member

    Crap.

    just copied files
     
  10. Slavik

    Slavik XenForo Moderator Staff Member

    To copy files like that, you have to stop mysql first otherwise you'll end up with data inconsistencies.
     
  11. digitalpoint

    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).
     
    Slavik likes this.
  12. Pope Viper

    Pope Viper Well-Known Member

    1. So am I beyond recovery?
     
  13. The Forum Heroes

    The Forum Heroes Well-Known Member

    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.
     
  14. CyclingTribe

    CyclingTribe Well-Known Member

    Did you read this bit Mike?

    ;)
     
    The Forum Heroes likes this.
  15. The Forum Heroes

    The Forum Heroes Well-Known Member

    Opps nope! I just saw - 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. and replied ;)
     
    CyclingTribe likes this.
  16. Pope Viper

    Pope Viper Well-Known Member

    I'm screwed.

    !@)_$*)!(@*$)(!@*#$)(@!*#
     
  17. Slavik

    Slavik XenForo Moderator Staff Member

    And that ladies and gentlemen, is why you should have a proper backup solution in place ;)
     
    The Forum Heroes likes this.
  18. Pope Viper

    Pope Viper Well-Known Member

    You're killing me.
     
  19. The Forum Heroes

    The Forum Heroes Well-Known Member

    Fixed :D
     
  20. Pope Viper

    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?
     

Share This Page