Author Topic: MariaDB - How to rescue the databases?  (Read 515 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
MariaDB - How to rescue the databases?
« on: August 13, 2021, 07:43:59 PM »
I did as instructed via the error message from CWP:

Quote
"**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf"
I have purchased support so I put in a ticket.

They got MariaDB working again but said I have lost all my data and need to restore from a back up...?

The thing of it is the /var/lib/mysql/  files are still there.

CWP and phpMyadmin where giving me infinite login loops for a couple of hours but that now seems to be working... but not really...

I go to upload one database using phpMyAdmin and I get errors Like the following error:


Quote
#1010 - Error dropping database (can't rmdir './DATABASE_IS_here', errno: 39 "Directory not empty")

I just preformed the following:

Quote
service mariadb stop

$mkdir /OLDMYSQL-DIR

cd /OLDMYSQL-DIR
tar cvf mysql-olddirectory.tar /var/lib/mysql gzip mysql-olddirectory.tar

service mariadb start


The day before this happened I did yum update and MariaDB was updated.


HOW CAN I RESCUE MY MYSQL DATABASES?

The latest support ticket I submitted was hours ago and one yesterday to ask what they did and how there was databases losses... I have still yet to here back.

I am worried that CWP is broke and that my databases are in jeopardy!

« Last Edit: August 13, 2021, 08:03:42 PM by ~Q~ »