zetaperu Posted April 2, 2018 Share Posted April 2, 2018 I return to my account that was recently unlocked and, when I access the remote MySQL, I find these error messages: Error while connecting to MySQL: (XID c7bqzj) Database Connect Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Any solution? Link to comment Share on other sites More sharing options...
zetaperu Posted April 2, 2018 Author Share Posted April 2, 2018 A few hours passed and the error message disappeared but the tables are not and if the stored procedures, I understand that there may be an update of the data in the account, it will be possible to re-obtain the tables? Link to comment Share on other sites More sharing options...
wolstech Posted April 2, 2018 Share Posted April 2, 2018 Were they InnoDB tables? If so, what we're their names? Link to comment Share on other sites More sharing options...
zetaperu Posted April 2, 2018 Author Share Posted April 2, 2018 Were they InnoDB tables? If so, what we're their names? That's right, how to solve it? Link to comment Share on other sites More sharing options...
wolstech Posted April 2, 2018 Share Posted April 2, 2018 They were lost during a crash a while back. We tell everyone not to use InnoDB because we've had such bad experiences with it (its stupidly sensitive to improper shutdowns destroying the data, usually colo power outages or servers crashing due to load). We've lost InnoDB data more times than I can count. On the other hand, we've never lost MyISAM data in our 13 years of operation. We may have a backup, but no guarantees. What was the name of the database? Link to comment Share on other sites More sharing options...
zetaperu Posted April 2, 2018 Author Share Posted April 2, 2018 zetaperu_buscameya Link to comment Share on other sites More sharing options...
wolstech Posted April 2, 2018 Share Posted April 2, 2018 Moving so Krydos can check for a backup. Link to comment Share on other sites More sharing options...
zetaperu Posted April 2, 2018 Author Share Posted April 2, 2018 Moving so Krydos can check for a backup.Krydos? Link to comment Share on other sites More sharing options...
wolstech Posted April 2, 2018 Share Posted April 2, 2018 One of our other root admins. He's the one who maintains the servers. I mostly do customer support and abuse prevention. Link to comment Share on other sites More sharing options...
zetaperu Posted April 2, 2018 Author Share Posted April 2, 2018 One of our other root admins. He's the one who maintains the servers. I mostly do customer support and abuse prevention. Right, there is a way to attach it to the thread or you have to start all the incident again? Link to comment Share on other sites More sharing options...
wolstech Posted April 3, 2018 Share Posted April 3, 2018 He'll email it to you if he has one, and usually posts in here saying it was emailed. Link to comment Share on other sites More sharing options...
Krydos Posted April 3, 2018 Share Posted April 3, 2018 A link to your backup has been emailed to your contact address. Link to comment Share on other sites More sharing options...
zetaperu Posted April 3, 2018 Author Share Posted April 3, 2018 Remove the BD because it generated problems to re-create the tables, now I try to create the BD again but this message comes out: (XID kxjpeb) La base de datos “zetaperu_buscameya” ya existe. That's right, how to solve it? Link to comment Share on other sites More sharing options...
wolstech Posted April 3, 2018 Share Posted April 3, 2018 (edited) It won't drop for some reason (gives me error 39 when I try to drop it). I'd suggest you just create a new database with a different name, then go into phpmyadmin and import the backup. Edited April 3, 2018 by wolstech Link to comment Share on other sites More sharing options...
zetaperu Posted April 3, 2018 Author Share Posted April 3, 2018 Right, and import backup, the question is whether you could later delete the BD zetaperu_buscameya and then rebuild it? And in my case defined the BD InnoDB engine is that why the crash or corruption of it, should change it to the MyISAM engine? Link to comment Share on other sites More sharing options...
Recommended Posts