To upgrade mysql using the CustomBuild script, adjust the following commands to the desired database type and version:
cd /usr/local/directadmin/custombuild
./build set mysql_backup yes
./build set "mysql" 5.7
./build set mysql_inst "mysql"
./build "mysql"
Where MariaDB can be 10.3, 10.4, 10.5 or 10.6 .
In place replacement between MariaDB and MySQL is no longer supported since the two DBMS have diverged too much.
If you have mysql_backup=yes set set in options.conf
file then a full raw SQL backup will be run prior to the upgrade. It goes without saying, always make backups, either with this tool or via other means. It makes sense to perform backup just once, next disable it during the upgrade by multiple hops. Read More
You don’t have dedicated server? get one from here