Comments - Mariadb crashed during deleting a database

2 weeks, 6 days ago Rich Ayoade

Thank you for your reply.

wow! You're saying things I was hoping not to hear already.

mysqldump threw an error as well: mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/run/mysql/mysql.sock' (111)" when trying to connect

There's got to be a way to connect and dump the (10 good databases for 3 sites!) databases on mariadb.

What else can be done?

 
2 weeks, 6 days ago Daniel Black

Try to start an 10.4 server on a copy of the data and take the dump from there.

per InnoDB Redo Log Directly editing or moving the redo logs can cause corruption, and should never normally be attempted.

 
2 weeks, 5 days ago Rich Ayoade

Thanks for your reply.

" per InnoDB Redo Log Directly editing or moving the redo logs can cause corruption, and should never normally be attempted." Thank you, well noted.

"start an 10.4 server on a copy of the data" I'm not sure I quite understand what you meant. Do you mean to install 10.4 and then use database backup?

Note: Only mariadb 10.2 came packaged with openSUSE Leap 15.1. I am not sure of 10.4 compatibility with openSUSE Leap 15.1.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.