Control Web Panel
WebPanel => MySQL => Topic started by: DragoCom on October 03, 2024, 04:11:07 AM
-
Will this method still work to go from 10.4 to 10.10?
https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4
-
Yes. The instructions are still valid with minor changes. You just need to change the line:
sed -i 's/10.2/10.4/g' /etc/yum.repos.d/mariadb.repo
Use the current MariaDB version installed on your server as the first argument and the new MariaDB version as the second argument.
-
It looks like it's still trying to install 10.4 anyway after doing those commands on that page. I can't install laravel without incresing to 10.10
[root@viking ~]# mysql -V
mysql Ver 15.1 Distrib 10.4.34-MariaDB, for Linux (x86_64) using readline 5.1
[root@viking ~]# cat /etc/redhat-release
AlmaLinux release 8.10 (Cerulean Leopard)
[root@viking ~]# mysqldump –all-databases > /tmp/all-database-backup.sql
mysqldump: Got error: 1049: "Unknown database '–all-databases'" when selecting the database
[root@viking ~]# rpm -qa|grep -i maria|grep "\-10.4."
MariaDB-devel-10.4.34-1.el8.x86_64
MariaDB-common-10.4.34-1.el8.x86_64
MariaDB-client-10.4.34-1.el8.x86_64
MariaDB-server-10.4.34-1.el8.x86_64
MariaDB-shared-10.4.34-1.el8.x86_64
[root@viking ~]# sed -i 's/10.4/10.10/g' /etc/yum.repos.d/mariadb.repo
[root@viking ~]# systemctl stop mariadb mysql mysqld
[root@viking ~]# systemctl disable mariadb
Removed /etc/systemd/system/multi-user.target.wants/mariadb.service.
Removed /etc/systemd/system/mysql.service.
Removed /etc/systemd/system/mysqld.service.
[root@viking ~]# rpm --nodeps -ev MariaDB-server
Preparing packages...
MariaDB-server-10.4.34-1.el8.x86_64
[root@viking ~]# yum clean all
81 files removed
[root@viking ~]# yum -y update "MariaDB-*"
CentOS Web Panel repo for Linux 8 - x86_64 1.7 MB/s | 305 kB 00:00
AlmaLinux 8 - BaseOS 13 MB/s | 7.4 MB 00:00
AlmaLinux 8 - AppStream 19 MB/s | 13 MB 00:00
AlmaLinux 8 - Extras 31 kB/s | 13 kB 00:00
AlmaLinux 8 - PowerTools 7.0 MB/s | 3.7 MB 00:00
AlmaLinux 8 - PowerTools Source 108 kB/s | 138 kB 00:01
AlmaLinux 8 - PowerTools debuginfo 666 kB/s | 610 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 22 MB/s | 14 MB 00:00
MariaDB 52 B/s | 10 B 00:00
Errors during downloading metadata for repository 'mariadb':
- Status code: 404 for http://mirror.mariadb.org/yum/10.10/centos8-amd64/repodata/repomd.xml (IP: 162.55.42.214)
Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
[root@viking ~]# yum -y install MariaDB-server
MariaDB 53 B/s | 10 B 00:00
Errors during downloading metadata for repository 'mariadb':
- Status code: 404 for http://mirror.mariadb.org/yum/10.10/centos8-amd64/repodata/repomd.xml (IP: 162.55.42.214)
Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
[root@viking ~]# systemctl enable mariadb
Failed to enable unit: Unit file mariadb.service does not exist.
[root@viking ~]# systemctl start mariadb
-
Wow, what a pickle. You should have full stopped after you didn't complete the backup all databases command at the beginning. That's really an essential prerequisite before doing a major version upgrade like this. Can you image the server as it sits (full VM backup or otherwise)?
-
I can't just re-install 10.4 again?
-
I have a snapshot from last night with Contabo:
SnapShot 10-2-24 02.10.2024 08:06
-
1. MariaDB 10.10.is EOL. It is better to upgrade MariaDB to 10.6 or 10.11.
2. Centos 8 aren't supported by MariaDB. It is EOL too.
You can upgrade MariaDB on Centos 8 to 10.10 still, but you need to download the binary packages (RPM) and install them manually. So I recommend you to upgrade MariaDB to 10.6 following the instructions:
https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4
with minor changes.
-
See
https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/ (https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/)
That will guide you to the upgrade to MariaDB 10.11.x (LTS)
-
1. MariaDB 10.10.is EOL. It is better to upgrade MariaDB to 10.6 or 10.11.
2. Centos 8 aren't supported by MariaDB. It is EOL too.
You can upgrade MariaDB on Centos 8 to 10.10 still, but you need to download the binary packages (RPM) and install them manually. So I recommend you to upgrade MariaDB to 10.6 following the instructions:
https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4
with minor changes.
I run almalinux 8.9 not centos. I solved it by using a snapshot from the day before.
-
MariaDB 10.4.x is past EOL.
10.11.x works on AlmaLinux 8.10 and 9.4 without problems.
Curious why you haven't updated to 8.10 for the security fixes.
-
MariaDB 10.4.x is past EOL.
10.11.x works on AlmaLinux 8.10 and 9.4 without problems.
Curious why you haven't updated to 8.10 for the security fixes.
I run update and upgrade all the time. I do all the yum updates as well but it's a production vps with lots of sites on it and can't afford for it to be down.
-
I run almalinux 8.9 not centos. I solved it by using a snapshot from the day before.
For some reason your OS is recognized as CentOS. Look at the string below:
- Status code: 404 for http://mirror.mariadb.org/yum/10.10/centos8-amd64/repodata/repomd.xml (IP: 162.55.42.214)
I run update and upgrade all the time. I do all the yum updates as well but it's a production vps with lots of sites on it and can't afford for it to be down.
I strongly recommend you to update MariaDB to 10.6 instead of 10.10. The upgrade process to 10.6 should be smooth without any problems.
-
I would redo your mariadb.repo, and put in the info for RHEL 8, you can find this at:
https://mariadb.org/download/?t=repo-config (https://mariadb.org/download/?t=repo-config)
You can also select the closest mirror to your location.
If using AL8, you really should be using dnf, instead of yum, just to get use to the newer stuff.
-
Thanks
-
I would redo your mariadb.repo, and put in the info for RHEL 8, you can find this at:
https://mariadb.org/download/?t=repo-config (https://mariadb.org/download/?t=repo-config)
You can also select the closest mirror to your location.
If using AL8, you really should be using dnf, instead of yum, just to get use to the newer stuff.
I jusdt setup dnf automatic
-
Ok so I attempted this again when I found a new tutorial at https://blog.alphagnu.com/update-upgrade-to-mariadb-10-4-on-vestacp-cwp-centos-7/.
Below is the resuklts of it, why did it go right back to 10.4?
[root@viking etc]# cp /etc/my.cnf /etc/my.cnf.bak
[root@viking etc]# nano /etc/my.cnf
[root@viking etc]# mv /etc/yum.repos.d/mariadb.repo /etc/yum.repos.d/mariadb.repo.bak
[root@viking etc]# nano /etc/yum.repos.d/mariadb.repo
[root@viking etc]# yum clean all
81 files removed
[root@viking etc]# yum install MariaDB-server MariaDB-client net-snmp perl-DBD-MySQL -y
CentOS Web Panel repo for Linux 8 - x86_64 302 kB/s | 305 kB 00:01
AlmaLinux 8 - BaseOS 18 MB/s | 9.6 MB 00:00
AlmaLinux 8 - AppStream 27 MB/s | 15 MB 00:00
AlmaLinux 8 - Extras 37 kB/s | 13 kB 00:00
AlmaLinux 8 - PowerTools 9.1 MB/s | 4.0 MB 00:00
AlmaLinux 8 - PowerTools Source 207 kB/s | 138 kB 00:00
AlmaLinux 8 - PowerTools debuginfo 1.2 MB/s | 688 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 30 MB/s | 14 MB 00:00
MariaDB 1.9 MB/s | 604 kB 00:00
nginx repo 1.1 MB/s | 71 kB 00:00
Package MariaDB-server-10.4.34-1.el8.x86_64 is already installed.
Package MariaDB-client-10.4.34-1.el8.x86_64 is already installed.
Package perl-DBD-MySQL-4.046-3.module_el8.6.0+2827+49d66dc3.x86_64 is already installed.
Dependencies resolved.
============================================================================================================================================================================================
Package Architecture Version Repository Size
============================================================================================================================================================================================
Installing:
net-snmp x86_64 1:5.8-30.el8 appstream 355 k
Upgrading:
MariaDB-client x86_64 10.6.20-1.el8 mariadb 15 M
MariaDB-common x86_64 10.6.20-1.el8 mariadb 88 k
MariaDB-server x86_64 10.6.20-1.el8 mariadb 26 M
Transaction Summary
============================================================================================================================================================================================
Install 1 Package
Upgrade 3 Packages
Total download size: 41 M
Downloading Packages:
(1/4): net-snmp-5.8-30.el8.x86_64.rpm 2.3 MB/s | 355 kB 00:00
(2/4): MariaDB-common-10.6.20-1.el8.x86_64.rpm 456 kB/s | 88 kB 00:00
(3/4): MariaDB-client-10.6.20-1.el8.x86_64.rpm 27 MB/s | 15 MB 00:00
(4/4): MariaDB-server-10.6.20-1.el8.x86_64.rpm 41 MB/s | 26 MB 00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 36 MB/s | 41 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: MariaDB-common-10.6.20-1.el8.x86_64 1/1
Upgrading : MariaDB-common-10.6.20-1.el8.x86_64 1/7
Upgrading : MariaDB-client-10.6.20-1.el8.x86_64 2/7
Running scriptlet: MariaDB-server-10.6.20-1.el8.x86_64 3/7
******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.4.34-1.el8.x86_64) is installed.
Upgrading directly from MySQL 10.4 to MariaDB 10.6 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.
A manual upgrade is required.
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program
This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %prein(MariaDB-server-10.6.20-1.el8.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server
Installing : net-snmp-1:5.8-30.el8.x86_64 4/7
error: MariaDB-server-10.6.20-1.el8.x86_64: install failed
Running scriptlet: net-snmp-1:5.8-30.el8.x86_64 4/7
Running scriptlet: MariaDB-client-10.4.34-1.el8.x86_64 5/7
error: MariaDB-server-10.4.34-1.el8.x86_64: erase skipped
Cleanup : MariaDB-client-10.4.34-1.el8.x86_64 5/7
Running scriptlet: MariaDB-client-10.4.34-1.el8.x86_64 5/7
Running scriptlet: MariaDB-common-10.4.34-1.el8.x86_64 6/7
Cleanup : MariaDB-common-10.4.34-1.el8.x86_64 6/7
Running scriptlet: MariaDB-common-10.4.34-1.el8.x86_64 6/7
Verifying : net-snmp-1:5.8-30.el8.x86_64 1/7
Verifying : MariaDB-client-10.6.20-1.el8.x86_64 2/7
Verifying : MariaDB-client-10.4.34-1.el8.x86_64 3/7
Verifying : MariaDB-common-10.6.20-1.el8.x86_64 4/7
Verifying : MariaDB-common-10.4.34-1.el8.x86_64 5/7
Verifying : MariaDB-server-10.6.20-1.el8.x86_64 6/7
Verifying : MariaDB-server-10.4.34-1.el8.x86_64 7/7
Upgraded:
MariaDB-client-10.6.20-1.el8.x86_64 MariaDB-common-10.6.20-1.el8.x86_64
Installed:
net-snmp-1:5.8-30.el8.x86_64
Failed:
MariaDB-server-10.4.34-1.el8.x86_64 MariaDB-server-10.6.20-1.el8.x86_64
Error: Transaction failed
[root@viking etc]# rm -rf /etc/my.cnf
[root@viking etc]# cp /etc/my.cnf.bak /etc/my.cnf
[root@viking etc]# systemctl enable mariadb
[root@viking etc]# service mysql start
Redirecting to /bin/systemctl start mysql.service
[root@viking etc]# mysql_upgrade
This installation of MariaDB is already upgraded to 10.4.34-MariaDB.
There is no need to run mysql_upgrade again for 10.4.34-MariaDB.
You can use --force if you still want to run mysql_upgrade
[root@viking etc]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5198
Server version: 10.4.34-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
-
Yum updates in CWP panel even fails:
Last metadata expiration check: 0:06:07 ago on Tue Dec 10 05:14:06 2024.
Dependencies resolved.
================================================================================
Package Architecture Version Repository Size
================================================================================
Upgrading:
MariaDB-devel x86_64 10.6.20-1.el8 mariadb 8.2 M
MariaDB-server x86_64 10.6.20-1.el8 mariadb 26 M
MariaDB-shared x86_64 10.6.20-1.el8 mariadb 128 k
galera-4 x86_64 26.4.20-1.el8 mariadb 1.7 M
Transaction Summary
================================================================================
Upgrade 4 Packages
Total download size: 36 M
Downloading Packages:
(1/4): MariaDB-shared-10.6.20-1.el8.x86_64.rpm 740 kB/s | 128 kB 00:00
(2/4): MariaDB-server-10.6.20-1.el8.x86_64.rpm 47 MB/s | 26 MB 00:00
(3/4): galera-4-26.4.20-1.el8.x86_64.rpm 4.2 MB/s | 1.7 MB 00:00
(4/4): MariaDB-devel-10.6.20-1.el8.x86_64.rpm 13 MB/s | 8.2 MB 00:00
--------------------------------------------------------------------------------
Total 57 MB/s | 36 MB 00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: galera-4-26.4.20-1.el8.x86_64 1/1
Running scriptlet: galera-4-26.4.20-1.el8.x86_64 1/8
Upgrading : galera-4-26.4.20-1.el8.x86_64 1/8
Running scriptlet: galera-4-26.4.20-1.el8.x86_64 1/8
Upgrading : MariaDB-shared-10.6.20-1.el8.x86_64 2/8
Running scriptlet: MariaDB-shared-10.6.20-1.el8.x86_64 2/8
Upgrading : MariaDB-devel-10.6.20-1.el8.x86_64 3/8
Running scriptlet: MariaDB-server-10.6.20-1.el8.x86_64 4/8
******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.4.34-1.el8.x86_64) is installed.
Upgrading directly from MySQL 10.4 to MariaDB 10.6 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.
A manual upgrade is required.
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
You may choose to use 'rpm --nodeps -ev ' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program
This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %prein(MariaDB-server-10.6.20-1.el8.x86_64) scriptlet failed, exit status 1
Running scriptlet: MariaDB-devel-10.4.34-1.el8.x86_64 5/8
error: MariaDB-server-10.6.20-1.el8.x86_64: install failed
error: MariaDB-server-10.4.34-1.el8.x86_64: erase skipped
Cleanup : MariaDB-devel-10.4.34-1.el8.x86_64 5/8
Running scriptlet: MariaDB-devel-10.4.34-1.el8.x86_64 5/8
Running scriptlet: MariaDB-shared-10.4.34-1.el8.x86_64 6/8
Cleanup : MariaDB-shared-10.4.34-1.el8.x86_64 6/8
Running scriptlet: MariaDB-shared-10.4.34-1.el8.x86_64 6/8
Running scriptlet: galera-4-26.4.18-1.el8.x86_64 7/8
Cleanup : galera-4-26.4.18-1.el8.x86_64 7/8
Running scriptlet: galera-4-26.4.18-1.el8.x86_64 7/8
Verifying : MariaDB-devel-10.6.20-1.el8.x86_64 1/8
Verifying : MariaDB-devel-10.4.34-1.el8.x86_64 2/8
Verifying : MariaDB-server-10.6.20-1.el8.x86_64 3/8
Verifying : MariaDB-server-10.4.34-1.el8.x86_64 4/8
Verifying : MariaDB-shared-10.6.20-1.el8.x86_64 5/8
Verifying : MariaDB-shared-10.4.34-1.el8.x86_64 6/8
Verifying : galera-4-26.4.20-1.el8.x86_64 7/8
Verifying : galera-4-26.4.18-1.el8.x86_64 8/8
Upgraded:
MariaDB-devel-10.6.20-1.el8.x86_64 MariaDB-shared-10.6.20-1.el8.x86_64
galera-4-26.4.20-1.el8.x86_64
Failed:
MariaDB-server-10.4.34-1.el8.x86_64 MariaDB-server-10.6.20-1.el8.x86_64
-
https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/#comment-25 (https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/#comment-25)
Probably your missing step is:
systemctl stop mariadb mysql mysqld
systemctl disable mariadb
rpm --nodeps -ev MariaDB-serverAnd note that 10.10 is already EOL. You should look to 10.11 LTS -- good through Feb 2028:
https://endoflife.date/mariadb (https://endoflife.date/mariadb)
-
Oh, and I am referencing from my notes that you should do a full reboot of the server after the MariaDB upgrade. Since CWP also lives in the DB, it gets a little confused (postfix, roundcube are also DB-reliant).
-
https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/#comment-25 (https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/#comment-25)
Probably your missing step is:
systemctl stop mariadb mysql mysqld
systemctl disable mariadb
rpm --nodeps -ev MariaDB-serverAnd note that 10.10 is already EOL. You should look to 10.11 LTS -- good through Feb 2028:
https://endoflife.date/mariadb (https://endoflife.date/mariadb)
So, to confirm I should do these commands first then do the commands I used above in the same order? I don't want to have to revive it again from a snapshot hehe
-
I would just follow Sandeep's full set of steps in the linked forum post. (It will remove MariaDB 10.4 and should take you to 10.11.9).
-
I would just follow Sandeep's full set of steps in the linked forum post. (It will remove MariaDB 10.4 and should take you to 10.11.9).
YESSSSS! Finally...Thank you sooooooo much.
Package Architecture Version Repository Size
============================================================================================================================================================================================
Installing:
MariaDB-server x86_64 10.11.10-1.el8 mariadb 28 M
Upgrading:
MariaDB-client x86_64 10.11.10-1.el8 mariadb 16 M
Installing weak dependencies:
pv x86_64 1.6.6-7.el8 epel 64 k
Transaction Summary
============================================================================================================================================================================================
Install 2 Packages
Upgrade 1 Package
Total download size: 44 M
Downloading Packages:
(1/3): pv-1.6.6-7.el8.x86_64.rpm 747 kB/s | 64 kB 00:00
(2/3): MariaDB-client-10.11.10-1.el8.x86_64.rpm 24 MB/s | 16 MB 00:00
(3/3): MariaDB-server-10.11.10-1.el8.x86_64.rpm 35 MB/s | 28 MB 00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 37 MB/s | 44 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Upgrading : MariaDB-client-10.11.10-1.el8.x86_64 1/4
Installing : pv-1.6.6-7.el8.x86_64 2/4
Running scriptlet: MariaDB-server-10.11.10-1.el8.x86_64 3/4
Installing : MariaDB-server-10.11.10-1.el8.x86_64 3/4
Running scriptlet: MariaDB-server-10.11.10-1.el8.x86_64 3/4
Cleanup : MariaDB-client-10.6.20-1.el8.x86_64 4/4
Running scriptlet: MariaDB-server-10.11.10-1.el8.x86_64 4/4
Running scriptlet: MariaDB-client-10.6.20-1.el8.x86_64 4/4
Verifying : pv-1.6.6-7.el8.x86_64 1/4
Verifying : MariaDB-server-10.11.10-1.el8.x86_64 2/4
Verifying : MariaDB-client-10.11.10-1.el8.x86_64 3/4
Verifying : MariaDB-client-10.6.20-1.el8.x86_64 4/4
Upgraded:
MariaDB-client-10.11.10-1.el8.x86_64
Installed:
MariaDB-server-10.11.10-1.el8.x86_64 pv-1.6.6-7.el8.x86_64
Complete!
[root@viking ~]#
-
I spoke too soon...I run this mode because of a php script that requires it.
[root@viking ~]# mysql_upgrade --force
mysql_upgrade: unknown variable 'sql_mode=NO_ENGINE_SUBSTITUTION'
[root@viking ~]#
-
Check the files in:
/root/.my.cnf
/etc/my.cnf
/etc/my.cnf.d/*
and disable "sql_mode" in every section except [mariadb], [server] then restart mariadb and run mariadb-upgrade (not mysql_upgrade) again.
-
Check the files in:
/etc/my.cnf
/etc/my.cnf.d/*
and disable "sql_mode" in every section except [mariadb], [server] then restart mariadb and run mariadb-upgrade (not mysql_upgrade) again.
Yeah I tried to create a db and it says it's created but doesn't show up.
-
Check the files in:
/root/.my.cnf
/etc/my.cnf
/etc/my.cnf.d/*
and disable "sql_mode" in every section except [mariadb], [server] then restart mariadb and run mariadb-upgrade (not mysql_upgrade) again.
Awesome you rock. That got my db'sa back and everything said OK so it's all good. I appreciate your help so much. So now if I need to put the strict_tables back where do you recommend I put it?
-
I recommend you to do it using the file:
/etc/my.cnf.d/server.cnf
in the section [mariadb].