This server just runs the tape backups so there are no users to worry about.
I'm very out of my depth now, normally just use MySQL/Mariadb with a little admin,. never had to repair this way.

Thanks again.

On Tue, Nov 24, 2015 at 1:00 PM, Reindl Harald <h.reindl@thelounge.net> wrote:


Am 24.11.2015 um 13:52 schrieb Carl Whalley:
Oh boy ...well I did get the service to start this way at least, but ...

[root@tiger etc]# systemctl restart mariadb.service
[root@tiger tmp]# mysql

well, i see a lot of error i can't explain

how many users do you have?

i would try to purge the whole "mysql" folder after stop the service and fire "mysql_install_db" to re-create the mysql-database or even go so far to configure mysqld for a different datadir, initialize it there and replace the "mysql" folder with the so new created

on any of my setups the whole "mysql" database is MyISAM and so table spaces should not matter, not sure if maraidb switched also to "innodb" as default engine

in doubt drop the whole database from your current instance runnign with "skip-grant" before stop it to get rid of tablespace rferences and at least for the fresh instance "default-storage-engine = myisam"

that way you should be able to merge the new created mysql-database with your current setup


_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp