Need Help MYsql corrupt

aaP_bilgicise

I can not do anything in my DB mysql
I think My sql instalation hase been corupt

I canot install, Update, or delet databse

aaPanel_Kern

Hello, please check the mysql error log
cat /www/server/data/*.err|grep -i -C 10 error

i have deleting mySql,
and install again,
I need update version my sql from 8.0.35 to 36
but always error ahave issue if in version 35

selecting download node...
https://jp1-node.bt.cn
selecting download node...
cat: /etc/redhat-release: No such file or directory
cat: /etc/redhat-release: No such file or directory
cat: /etc/redhat-release: No such file or directory
cat: /etc/redhat-release: No such file or directory
mysql.sh: line 50: rpm: command not found
mysql.sh: line 51: rpm: command not found
Reading package lists...
Building dependency tree...
Reading state information...
libgnutls28-dev is already the newest version (3.7.3-4ubuntu1.5).
0 upgraded, 0 newly installed, 0 to remove and 12 not upgraded.

aaPanel_Kern

Hello, is there any more log information? What is your operating system and what version?
The latest quick installation is currently 8.0.35, and the latest one is compiled and installed.

aaP_bilgicise

i need upgrade to 8.0.36 can ..?

aaPanel_Kern

Hello, upgrading requires compilation and installation. It is recommended to take a server snapshot backup before upgrading. If the service is running stably, it is not recommended to upgrade.

aaP_bilgicise

aaPanel_Kern

how to make compilation and installation ? give me step by step

i use this 8.0.35 is not stably for me
if posibel to install manual via SSh give me step

aaPanel_Kern

Hello, if you have already installed it, you can upgrade it directly. If you don’t have mysql installed, please use compiled mode to install it.

aaP_bilgicise

i hvae instaledd 8.0.35
how to upgrade

upgrade always failed

ysql.sh
Resolving node.aapanel.com (node.aapanel.com)... 172.67.171.7, 104.21.79.196, 2606:4700:3031::6815:4fc4, ...
Connecting to node.aapanel.com (node.aapanel.com)|172.67.171.7|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 57559 (56K) [application/octet-stream]
Saving to: ‘mysql.sh’

0K .......... .......... .......... .......... .......... 88% 32.9M 0s
50K ...... 100% 129M=0.002s

2024-12-03 17:12:18 (35.9 MB/s) - ‘mysql.sh’ saved [57559/57559]

0 upgraded, 0 newly installed, 0 to remove and 12 not upgraded.

检测到当前空闲内存为2155MB, 编译安装 MySQL-8.0至少需要 4096MB 空闲内存才可以进行安装
请尝试在面板首页中释放内存后再尝试安装
如内存仍不足,可执行以下命令后尝试安装,将会跳过内存验证,强制安装
命令：touch /www/server/panel/install/i_mysql.pl
注：强制安装将可能导致服务器异常，请做好备份！
部分系统不支持极速安装，仅支持编译安装，如出现使用极速安装提示上面的提醒
建议更换 CentOS-7/Ubuntu-22/Debian-12 进行极速安装
|-Successify --- Command executed! ---

aaPanel_Kern

The memory is still insufficient. You can execute the following command and try to install it. The memory verification will be skipped and the installation will be forced.
Command: touch /www/server/panel/install/i_mysql.pl

aaP_bilgicise

how to full deactivated my sql

当前已有数据库正在运行停止安装!

aaP_bilgicise

selecting download node...
https://hk1-node.bt.cn
selecting download node...
cat: /etc/redhat-release: No such file or directory
cat: /etc/redhat-release: No such file or directory
cat: /etc/redhat-release: No such file or directory
cat: /etc/redhat-release: No such file or directory
mysql.sh: line 50: rpm: command not found
mysql.sh: line 51: rpm: command not found
Reading package lists...
Building dependency tree...
Reading state information...
libgnutls28-dev is already the newest version (3.7.3-4ubuntu1.5).
0 upgraded, 0 newly installed, 0 to remove and 12 not upgraded.
Reading package lists...
Building dependency tree...
Reading state information...
cmake is already the newest version (3.22.1-1ubuntu1.22.04.2).
0 upgraded, 0 newly installed, 0 to remove and 12 not upgraded.
当前已有数据库正在运行停止安装!
|-Successify --- Command executed! ---

i have run this /etc/init.d/mysqld stop

aaPanel_Kern

Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
It is recommended to fill in the following
Post link:
SSH IP address, account password and port:
aapanel login link address and account password:
Detailed problem description:

No post link will not be able to know which user's information is, and the problem will not be processed

aaP_bilgicise