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.
6 фрилансеров(-а) готовы выполнить эту работу в среднем за $152
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