How do I change MySql 5.7.4.4 to MySql 8?
How to change MySql version 5.7.4.4 to 8?
Hello, it is recommended to take a server snapshot backup before operation to avoid other errors or data loss.
Back up all databases first, then uninstall mysql, and then install mysql
If the installation is not successful, please check the installation log:/tmp/panelExec.log
Previously, the MySql management interface allowed you to select a version. Currently, it is not possible to select a version.
Hello, you need to back up the database first when switching versions.
Hello.
aaPanel_Kern have the truth.
You need backup all data bases and restore it later.
Then you can remove folder or rename. Do "rm -rf /www/server/mysql" or rename folder "/www/server/mysq" to mysql_old.
Then install MySQL and restore databases one by one or bulk it.
Else you can get this message in WebSite assistant.
Site database [sql_example_com] failed to query users, try setting the database for this site. Error: (1146, "Table 'sql_example_com.wp_expusers' doesn't exist")
aaP_gongora121 I'm trying to explain that I don't see the option to choose a version.
Where can I choose a version? ( MySQL )
Hello, you need to uninstall first and then select the version when installing.
Note that please back up the database or take a server snapshot first
8 days later
Hello I did this.
Backup all databases.
You can use:
mysqldump -u root -p --opt --all-databases > alldb_opt.sql
mysqldump -u root -p --all-databases --skip-lock-tables > alldb_sk_l_t.sql
or phpMyAdmin Export Custom with:
Add DROP DATABASE IF EXISTS statement
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement
If you have alot of db export one by one. Remember change php upload size, ram and time if u need it.
Do "rm -rf /www/server/mysql" or rename folder "/www/server/mysq" to mysql_old.
Install new MySQL.
Recover all databases with new root password.
Fix aaPanel.