how to change mysql 5.0 to mysql 8.0

aaP_prajapatsam98

how to change mysql 5.0 to mysql 8.0
first time when i am changing to 8.0 then error show 2 core cpu required

after updated cpu 1 core to 2core

now its asking to upgrade ram minimum 3700mb
but not to much use ram on my server
please give me solution

in past i am using mysql 8.0 in 1 core 1gb ram in whm cpanel

now i move to aapanel please help me mysql 8.0 version needed

aaPanel_Kern

aaP_prajapatsam98
Hello, try to use the linux tools tool in the app store to add 4G swap to see if it can be installed.
5.0 upgrade to 8.0 is to compile and install. This process is very, very slow, and the installation will fail if there is not enough memory.
It is recommended that after backing up all databases, Uninstall mysql, and then choose quick installation when installing mysql. After the installation is successful, add the database and restore the database
It is best to make a snapshot backup of the server.

aaP_prajapatsam98

aaPanel_Kern
how can i upgrade using terminal?

if i update ram and upgrade mysql 8.0 after install mysql 8.0 can i downgrade ram?
please reply all question point by point

Thanks

sorry i have 20+ domain or subdomain i can't remove aur install aur fresh installation

aaPanel_Kern

aaP_prajapatsam98
Whether it is panel, terminal upgrade msql. You need to back up the database first, and it is recommended to take a snapshot backup of the server.
Upgrading mysql will delete the old mysql program and then install the new version.
Upgrade/replace commands:
/www/server/panel/install/mysql.sh update 8.0

You can add and reduce the swap size at any time
Upgrading is risky, do not upgrade unless there are special circumstances

aaP_prajapatsam98

how can i take database table backup before install mysql 8.0

aaPanel_Kern

aaP_prajapatsam98
Why table backup? Can't backup the entire library? Table backup requires phpmyadmin