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

Operating System & Version
Centos 7

in4hs

Registered
Jun 4, 2020
2
0
1
pakistan
cPanel Access Level
Root Administrator
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

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston
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:


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:

 

in4hs

Registered
Jun 4, 2020
2
0
1
pakistan
cPanel Access Level
Root Administrator
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.
 

cPSamuelM

Technical Analyst Team Lead
Staff member
Nov 20, 2019
196
37
103
USA
cPanel Access Level
Root Administrator