MariaDB Database Recover / Corruption After Deleting ibdata1

Closed Posted 3 years ago Paid on delivery
Closed Paid on delivery

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 Linux Database Administration Database Programming System Admin

Project ID: #25594018

About the project

5 proposals Remote project Active 3 years ago

5 freelancers are bidding on average $145 for this job

vili1977

Hello. I would like to help you with fixing innodb data. I have experence. Please read my feedbacks. Thank you.

$40 USD in 1 day
(961 Reviews)
7.6
gdmlnx

Hi there, hope you are doing just fine!. I would like to discuss your project. please find my resume below. I'm an experienced system Admin; I'll be glad to assist you , have a great day! over 10 years of unix and uni More

$140 USD in 1 day
(57 Reviews)
5.7
khansourov597

I am skill less

$156 USD in 6 days
(0 Reviews)
0.0
kkshah0091

Respect Client  we have gone through the requirements and I can do this project  and can show you Free demo work as well  Do you want demo ? let me know 

$140 USD in 7 days
(0 Reviews)
0.0