Goodmorning everyone. I have upgraded Debian from 9 to 10. The mariadb database no longer recognizes the databases and the "collation" is always in the "use" state. Only the ISPConfig database had no backlash and works perfectly, but everything else doesn't work. View attachment 6762
Was this done following upgrade instructions in https://www.debian.org/releases/stable/releasenotes ? Have you after the OS upgrade forced ISPConfig to reconfigure services with Code: ispconfig_update.sh --force Then follow instructions in https://www.howtoforge.com/community/threads/please-read-before-posting.58408/ to rule out the usual suspects.
First, make a backup of all mysql databases. You can do that e.g. by stopping MySQL and then making a copy of the whole /var/lib/mysql folder. Then start MySQL again. Afterwards, try to repair the databases using 'mysqlcheck' command. Example: mysqlcheck --defaults-file=/etc/mysql/debian.cnf --all-databases --optimize --auto-repair --silent
Hi dear Mr. Till, I report that all tables not exist in databases. Example: c161.wp_options Error : Table 'c161.wp_options' doesn't exist in engine
That's because your issue is not ISPConfig related. The reason for your issue seems to be damaged MySQL database files.
