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

[in4hs]

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]

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:

Tutorial - InnoDB Corruption Repair Guide

InnoDB Corruption Repair Guide Understanding that our ability as technicians to responsibly assist with InnoDB corruption is very limited, I wanted to offer a basic guide that goes over some of the methods you can use to deal with some of the...

forums.cpanel.net

If you're uncomfortable with this, you may wish to contact a qualified database administrator and may find one to consult with at the following:

System Administration Services

System Administration Services Listings Have No Affiliation to cPanel What is SafeAdmin Accreditation? SafeAdmin Certified Service Providers have ensured that a minimum of 90% of their support technicians have successfully completed a...

go.cpanel.net

 

[in4hs]

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.

 

[SamuelM]

Hello @in4hs

I do recommend you refer to the InnoDB Corruption Repair Guide Lauren shared earlier.

If you prefer to reinstall MariaDB from scratch, you may find the instructions in this forum post helpful:

https://forums.cpanel.net/threads/u...h-again-restoration-issue.618159/post-2510003