Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I recently formatted my PC which had MySQL running on it. As a result, I lost the databases on my hard drive.

I tried to restore the databases by re-installing the MySQL Server and putting the databases back into the MySQL datafiles folder. When I started the MySQL service, I got error 1067: Windows could not start the MySQL Service on local computer.

If I just install MySQL and do not put my databases into the datafiles folder, I don't get the error.

How can I successfully restore my databases?

I'm using Windows Server 2008 R2 enterprise.

share|improve this question

migrated from stackoverflow.com Apr 25 '12 at 17:15

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 2 down vote accepted

After putting the data files, remove ib_logfile0 and ib_logfile1. Dont delete ibdata1 file. And then restart MySQL service.

Before deleting take the backup of ib_logfiles and then delete.

Just give a try in this way.

share|improve this answer
    
thanks man. It works correct now. Thank you very much. –  Patrick Bassut Apr 26 '12 at 18:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.