Re: MySQL corrupting database everytime it starts
on another forum, i was told to try to put "innodb_file_per_table" in the config. i did this and deleted the ib_logfile0, ib_logfile1, and ibdata1 files. it let me actually delete the database from the MySQL interface. though, once i added the database back to check if everything was fixed, it did the same thing, and went back to being corrupted and unable to be removed.. giving this error:
#1010 - Error dropping database (can't rmdir '.\minecraft', errno: 41)
also added:
character-set-server=utf8
collation-server=utf8_unicode_ci
to my config. didn't help, but it was worth a try.
also, something i noticed. when deleting the corrupted files, it saves as users.ibd and the one i can access is saved as Users.frm if that means anything...
Subject
Written By
Posted
Re: MySQL corrupting database everytime it starts
June 01, 2014 09:28PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.