RayDude Advocate
Joined: 29 May 2004 Posts: 2062 Location: San Jose, CA
|
Posted: Sat Sep 22, 2018 4:52 pm Post subject: mariadb help... |
|
|
Mariadb just updated. dispatch-conf wanted to change my my.cnf and I foolishly let it. I've lost all my databases...
Yet ...
datadir = /var/lib/mysql
is correct
and the files are there.
What changed?
I have a lot of data in there...
Halp?
Update, I have a back up of the old my.cnf and nothing significant changed which is why I allowed it...
Code: | server /etc/mysql # diff -u /mnt/backup/etc/mysql/my.cnf my.cnf
--- /mnt/backup/etc/mysql/my.cnf 2018-07-28 22:16:46.616395084 -0700
+++ my.cnf 2018-09-21 23:24:28.202660077 -0700
@@ -7,34 +7,34 @@
socket = /var/run/mysqld/mysqld.sock
[mysql]
-character-sets-dir=/usr/share/mysql/charsets
+character-sets-dir=/usr/share/mariadb/charsets
default-character-set=utf8
[mysqladmin]
-character-sets-dir=/usr/share/mysql/charsets
+character-sets-dir=/usr/share/mariadb/charsets
default-character-set=utf8
[mysqlcheck]
-character-sets-dir=/usr/share/mysql/charsets
+character-sets-dir=/usr/share/mariadb/charsets
default-character-set=utf8
[mysqldump]
-character-sets-dir=/usr/share/mysql/charsets
+character-sets-dir=/usr/share/mariadb/charsets
default-character-set=utf8
[mysqlimport]
-character-sets-dir=/usr/share/mysql/charsets
+character-sets-dir=/usr/share/mariadb/charsets
default-character-set=utf8
[mysqlshow]
-character-sets-dir=/usr/share/mysql/charsets
+character-sets-dir=/usr/share/mariadb/charsets
default-character-set=utf8
[myisamchk]
-character-sets-dir=/usr/share/mysql/charsets
+character-sets-dir=/usr/share/mariadb/charsets
[myisampack]
-character-sets-dir=/usr/share/mysql/charsets
+character-sets-dir=/usr/share/mariadb/charsets
# use [safe_mysqld] with mysql-3
[mysqld_safe]
@@ -59,7 +59,7 @@
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
-lc_messages_dir = /usr/share/mysql
+lc_messages_dir = /usr/share/mariadb
#Set this to your desired error message language
lc_messages = en_US
|
Yet, when I init mysql and run mysql, my databases are missing even though I can see them on the hard drive.
Update: now it's running fine. What changed? Nothing as far as I know...
But mythtv 28 is not compatible with this version and the version I need is gone from the repo... I guess it's up to me to get mythtv 29 working... except I tried and it wouldn't work...
crap. there goes my Saturday. _________________ Some day there will only be free software. |
|