• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Question How to downgrade MariaDB from 10.5.10 to 10.3.22 or higher

max2334

New Pleskian
Hi,

how can I downgade MariaDB from 10.5.10 to 10.3.22 or higher, because I want to install Shopware 6 and Shopware 6 has some issue with 10.3.29, 10.4.19 and 10.5.10. So I need to downgrade my MariaDB. any idea?

thanks
Max
 
hello @max2334 ,
what OS and Plesk version are you use ?
do you have MariaDB installed from vendor's repo or from community repo (in case Linux) ?

downgrade procedure is very dangerous and does not supported by Plesk in automatic mode.
 
Because MariaDB 10.3.28 contains an annoying bug, I updated to version 10.5.10 yesterday.

I used these instructions:  How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?

Maybe you can use these instructions to downgrade as well. In the MariaDB.repo place the info belonging to version 10.4 instead of version 10.5.

Before you begin: make a backup.

I cannot guarantee it will work, but from the other hand ... why wouldn't it? But do make a backup first.

EDIT: read this first

Downgrading could go wrong ...

 
@max2334
in general, you can try to remove MariaDB 10.5 from your system with no-depends; install MariaDB10.3 and restore of full backup of all your databases.

but I'm not sure that dump which was created at MariaDB 10.5 will be able to be successfully restored at MariaDB 10.3.
so, even you will have a backup it may not help you.

I strongly not recommend to proceed with DB downgrade if you not sure what are you doing.
 
Shopware is currently NOT compatible* with all the latest releases of: MariaDB 10.3, MariaDB 10.4, MariaDB 10.5, MySQL 8.0 (* due to some dumb table create statements in the installer)

So, a simple downgrade to MariaDB 10.3 will not help here, as you most likely get v10.3.29 that way.

It's better to continue using MariaDB 10.5 and just fix that Shopware Installer-Script. (or wait till Shopware ships the next release with this fix already in it)

In order to fix that yourself, just locate the file "Migration1563805586AddLanguageToOrder.php" and replace it's content with this: shopware/platform
 

Attachments

  • shopware.png
    shopware.png
    15.3 KB · Views: 31
Back
Top