I just do not want to get going in too many directions as I am already 100% confused on how this happened and how to get my wordpress site back up.
Do I continue trying to fix the mysql frozen install or something else?
as @stefan1959 says did you install mysql instead of maria ? hence the missing config files.
as soon as maria is restored your web site will work again
ok, how do I do that?
do a search for maria and mysql maybe, see whats is installed.
where do I do this search?
yes you do have mysql installed rather than maria I missed that
best way to move forward now?
like my screenshot, in webmin software packages
ok
apt list maria*
from the command line
seaarch for maria shows nothing… for mysql shows
Packages matching mysql
Package Class Description
mysql-client-8.0 8.0.32-0ubuntu0.22.04.2 K-O MySQL database client binaries
mysql-client-core-8.0 8.0.32-0ubuntu0.22.04.2 K-O MySQL database core client binaries
mysql-common 5.8+1.0.8 K-O MySQL database common files, e.g. /etc/mysql/my.cnf
mysql-server 8.0.32-0ubuntu0.22.04.2 K-O MySQL database server (metapackage depending on the latest version)
mysql-server-8.0 8.0.32-0ubuntu0.22.04.2 K-O MySQL database server binaries and system database setup
mysql-server-core-8.0 8.0.32-0ubuntu0.22.04.2 K-O MySQL database server binaries
php-mysql 8.1+92ubuntu1 P-T MySQL module for PHP [default]
php8.1-mysql 8.1.2-1ubuntu2.11 P-T MySQL module for PHP
you 100% sure you had mariaDB orginally?
sudo apt list maria*
[sudo] password for jc:
Listing… Done
maria-doc/jammy 1.3.5-4.1build2 all
maria/jammy 1.3.5-4.1build2 amd64
mariadb-backup/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-client-10.6/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-client-core-10.6/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-client/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 all
mariadb-common/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 all
mariadb-plugin-connect/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-plugin-cracklib-password-check/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-plugin-gssapi-client/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-plugin-gssapi-server/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-plugin-mroonga/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-plugin-oqgraph/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-plugin-rocksdb/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-plugin-s3/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-plugin-spider/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-server-10.6/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-server-core-10.6/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
mariadb-server/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 all
mariadb-test-data/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 all
mariadb-test/jammy-updates,jammy-security 1:10.6.12-0ubuntu0.22.04.1 amd64
jaycee@twebserver:/etc/mysql$
Yes i am 100% sure. Maria DB waas active and running and my wordpress site working fine for last month. Then my site went down with database error went to virtual min and saaw Maaria DB was turned off but when I hit the play button it would not come back on.
Jim maybe best on the reinstall.
Now in my server status where is previously showed MariaDB as turned off it now shows MySQL Database Server as turned off and no more MariaDB at all like it vanished.
I think I am just digging my hole deeper and deepr here. Everytime I try to solve a problem i create 10 more.
Why not revert to a BACKUP?
So simple really there is a very good reason why we make (or learn to make) system backups. If a system goes from working to not working it takes very little down time to wind back to a previous happy state.
System Admin 101
That was the first thing I tried, i have weekly backups setup but when I went back to the lst one on the 24th I still had the same database issue with MariaDB. I guess I could do that again and event hough it would not solve my issue it would reset everything I have done over the past few hours trying to fix it.
Ok you have maria ready to install,
you need to copy /var/lib/mysql somewhere
or rename it with
cp -r /var/lib/mysql /var/lib/mysql.old
then remove mysql server
sudo apt purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*
then install maria
sudo apt install mariadb-server mariadb-client
ok did all that… only erorr seems to be
E: Sub-process /usr/bin/dpkg returned an error code (1)
at least you have a backup of all the data