Accidentally uninstalled MariaDB, help please?

profzelonka

Explorer
Joined
Mar 29, 2020
Messages
67
I have nextcloud running with @danb35's script, and wanted to install libreoffice to add more thumbnail previews for files.

I didn't realize it said it wants to remove MariaDB before installing.. /facepalm
To try and fix it, I reinstalled the same version of mariadb which prompted me to uninstall libreoffice and mysql.
Now if I run mysql I get:
Code:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)

In nextcloud.erro I also saw
Code:
2020-04-14T08:35:20.403618Z 0 [ERROR] InnoDB: The Auto-extending innodb_system data file '/var/db/mysql/ibdata1' is of a different size 4864 pages (rounded down to MB) than specified in the .cnf file: initial 8192 pages, max 0 (relevant if non-zero) pages!
2020-04-14T08:35:20.403643Z 0 [ERROR] InnoDB: Plugin initialization aborted with Generic error
2020-04-14T08:35:20.713101Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-04-14T08:35:20.713127Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-04-14T08:35:20.713135Z 0 [ERROR] Failed to initialize builtin plugins.
2020-04-14T08:35:20.713139Z 0 [ERROR] Aborting

I'm not sure if this directory of my.cnf is the wrong one now, but I went ahead and changed the setting to 64M from 128M in /usr/local/etc/mysql/my.cnf
But now in the log I'm blocked by Unsupported redo log format. The redo log was created with MariaDB 10.3.22.
When I run mysql -V :
Code:
mysql Ver 15.1 Distrib 10.3.22-MariaDB, for FreeBSD11.3 (amd64)

Help would be greatly appreciated. I'm still new to FreeBSD and FreeNAS..
 
Top