transfer from server with mariadb 10.3 to server with mysql 8.0
When try transfer from a server with Mariadb10.3 to Mysql 8.0 transfer in some databases got error and do not work.
However, when do a fullbackup and a restore work always well.
Now i need transfer a large site(more then 200G) and transfer is better option (site not stop).
Anyone know why in fullbackup and restore work fine, but not in direct transfer?
Thank You!!!
-
seems user in "stream account transfer" is username and with "restorepkg" is root. Solve this, first transfer (server load is much lower), then dump db with root permissions. Account transfer needs an option to allow restore with root or any other mechanism or option that allows transferring the db without issues. 0 -
@bitpt - if you're seeing issues with the Transfer Tool, could we get access to a server experiencing that problem so we can check that out? 0 -
one or both ??? 0 -
When you create the support ticket with our team we'd need access to both the Source and Destination so we can check the migration details. 0 -
I already migrate all dbs and is working fine. If you want find what happened for this stream migration fail, thats ok, but pls don't migrate again, server already working after dumping dbs. Can you send ticket link or submit a normal ticket? 0 -
You would just need to submit a normal ticket. 0 -
This is a shame. I buy a new server that is different than others due AlmaLinux 8 and cPanel 104 has not MariaDB on the selector like others, it installs mysql 8 by default. MySQL 8 is somekind of crap, comparing to MariaDB 10.3 that is better in all aspects. I don't know why cPanel adopts that decision, maybe commercial topics. 0 -
Is there a specific issue you're having with MySQL 8? 0 -
cPanel should show that pink box on the installation process!! Our usual experience tell us that we can change the db engine after install.... but that's not the case. 0 -
@Timway Support - is there a certain issue you're running into with the installation? 0 -
We use the usual installation command we found on Installation | cPanel & WHM Documentation to install a new cPanel server for migration. We run the script as usual, after cPanel installed, we found that there is no way to change the database engine to Mariadb and stuck in MySQL 8.0 Our original server is running Mariadb, and we want to keep everything as smooth as possible. We have to use Mariadb. So what we done? we take down the server from the production rack and reinstall the OS again. And on this guild, no pink warning box Installation | cPanel & WHM Documentation The pink box only show on this customization page: 0 -
There is currently not a supported way to move back to MariaDB from MySQL 8 as that is considered a downgrade. 0 -
We are looking for cPanel to show more noticeable message on the installation process, and require the operator to confirm / select (any interaction) a db engine type for a irreversible installation process. 0 -
Can you use the link in my signature to submit a feature request, or would you like me to do that for you? 0 -
Please create the feature request for us. I guess you are more familiarize with it and need to know what kind of information need to provide. Thank you. 0 -
Thank you for your help. 0 -
Sure thing! 0
Please sign in to leave a comment.
Comments
22 comments