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.
17 фрилансеров(-а) готовы выполнить эту работу в среднем за $418
I understood your issue with your database and may help you with it I don't see any files attached tho so send in via inbox I won't be taking any outside payment but on freelancer.com only Thanks!
Hey Akina, Ping me back, so we can discuss this MySQL issue in detail. Share you server credentials with me, So I can connect and verify above errors. Regards, Nabeel Abid.
Greetings, I'm experienced with MariaDb and SQL. I'm on the field since 6 years ago. Let me help you, i'm sure that i will not take much longer. Regards, Armando Freitas.
Hi, I understand your project requirement. I have huge experience in Web development. Please get in touch with me for further process. Thanks and Regards Anuj
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