I am trying to remove all of this sql and then start again on mariadb, but it still sais warning and errors:
sudo apt remove mysql-server mysql-client mariadb-server mariadb-client
sudo apt auroremove mysql-server mysql-client mariadb-server mariadb-client
sudo apt purge mysql-server mysql-client mariadb-server mariadb-client
sudo apt update
sudo apt upgrade
There are full of errors here. See the four pictures (remove, auroremove, purge and upgrade): https://ibb.co/r6zcTDf, https://ibb.co/Xk7pPLk, https://ibb.co/KhLxPpw and https://ibb.co/khdgmJr.
commando:
/var/www/html/test.com/index.php //<?php phpinfo();
website https://test.com/index.php:
404 Not Found
nginx/1.18.0 (Ubuntu)
/var/log/mysql/error.log
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20-0ubuntu0.20.04.1) (Ubuntu).
[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-0ubuntu0.20.04.1) starting as process 28629
[System] [MY-011012] [Server] Starting upgrade of data directory.
[System] [MY-013576] [InnoDB] InnoDB initialization has started.
[ERROR] [MY-012936] [InnoDB] Database upgrade cannot be accomplished with innodb_force_recovery > 0
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20-0ubuntu0.20.04.1) (Ubuntu).
I have innodb_force_recovery = 1
on /etc/mysql/mysql.conf.d/mysqld.cnf, but that didn’t help me.
Can you help me?
Go to Source
Author: Oldie