MariaDB Database Recover / Corruption After Deleting ibdata1

today my MaraDB wasn't starting up so i read on some forums to delete the InnoDB log files along them i deleted ibdata1.

Which ofcrouse erased all data map of my InnoDB Tables, but then i searched and after some time i found out that i can restore the tables using the frm files.

So i started and restored all my tables except only 1

The commands i used to restore them are attached below.

So the last table file

Gave an error after obtaining the query from dbsake, i made a thread on DB Exchange [login to view URL]

And someone tried to help,

So he modified my Query to this [login to view URL]

And after running the Query about 20 secs later, i cant do anything on the Database

I can only select it, but when i command to show tables; it says

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/[login to view URL]' (111)

ERROR: Can't connect to the server

Basically on every command it gives this, The site is live though, but i cant even delete the filenew table now.

Can you please help, i have attached the server details too. And also send me your PayPal so that i can pay for the work.

MySQL 리눅스 데이터베이스 행정 데이터베이스 프로그래밍 시스템 관리인

프로젝트 ID: #25594018

프로젝트 소개