MySQL Forums
Forum List  »  General

Re: MySQL corrupting database everytime it starts
Posted by: Nekrose DeCuir
Date: June 01, 2014 09:28PM

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

Options: ReplyQuote


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.