innodb crashed ibdata files deleted shifted to MYISAM but having some issues if u could help

in4hs

• June 04, 2020 15:20

Hello. IBDATA and log files were deleted accidently.. i tried to recover but i couldnt because mysql was restarted several times before that. i couldnt recover it.. i had to manually delete all the tables using innodb because they were showing " IN USE " at the moment. im currently using DB governor with Mariadb 10.3 .. i have to turn on Innodb again now.. but having many issues.. some of them are : [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found. mainly when someone tries to install something in innodb it says [ERROR] InnoDB: Cannot create file xxxx/xxxxx/xxx.ibd already exists. [ERROR] InnoDB: Cannot rename because the target file already exists. some sort of these problems. i cannot explain more because its been many days i cleared the Error logs as well.. is there a way to fix these things ? or is there a way to reinstall mariadb 10.3 ?? im currently using innodb=OFF in my.cnf .. and all the tables remaining are on MYISAM only in the mysql. but user folder contains .ibd and .frm files as well. i will be waiting for your reply.. Regards Steps to reproduce: A- Deleted all the Innodb Tables from Phpmyadmin via mysql command line. B- shifted the Mysql to only allow MYISAM turning Skip-innodb

• 

  cPanelLauren

  • June 04, 2020 23:15

  We have Hello, Thanks for contacting us today! I'm sorry to hear about the issues you're experiencing with MySQL on this server This issue is something that we can't assist you with though others are welcome to provide their suggestions as well. We've also got some general suggestions and a guide below: You may want to increment "innodb_force_recovery" from 1 to 2 and so on in the server's MySQL configuration at /etc/my.cnf, restarting MySQL each step along the way in an effort to repair the corruption InnoDB is encountering when it starts up. If you are familiar with linux command line, the following guide is quite helpful and extremely detailed for database restoration and repairing InnoDB:

  0
• 

  in4hs

  • June 05, 2020 17:45

  just letme know how to reinstall mariaDB 10.3, is there some way to reinstall it ?.. i will DUMP the mysql data first and restore it after i reinstall the mysql.

  0
• 

  SamuelM

  • June 06, 2020 01:55

  Hello @in4hs I do recommend you refer to the

  0

Please sign in to leave a comment.