Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

On Wed, 16 Oct 2019, 11:07 Reindl Harald, wrote: > > > Am 16.10.19 um 11:59 schrieb Gordan Bobic: > > I have seen failures when upgrading from 10.0, with the latest 10.1 -> > > 10.2 -> 10.3 -> 10.4 unless I issued a clean shutdown between the latest > > 10.1 and 10.2 as recently as last week, wit

Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

Am 16.10.19 um 11:59 schrieb Gordan Bobic: > I have seen failures when upgrading from 10.0, with the latest 10.1 -> > 10.2 -> 10.3 -> 10.4 unless I issued a clean shutdown between the latest > 10.1 and 10.2 as recently as last week, with the latest RPMs for each > version. > > You are trying to

Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

I have seen failures when upgrading from 10.0, with the latest 10.1 -> 10.2 -> 10.3 -> 10.4 unless I issued a clean shutdown between the latest 10.1 and 10.2 as recently as last week, with the latest RPMs for each version. You are trying to make an argument analogous to "smoking can't be harmful b

Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

Am 16.10.19 um 11:29 schrieb Gordan Bobic: > On Wed, Oct 16, 2019 at 10:17 AM Reindl Harald > wrote: > > > Am 16.10.19 um 10:23 schrieb Gordan Bobic: > > I don't know if it is recoverable but it sounds like you missed > the step > > of always need

Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

On Wed, Oct 16, 2019 at 10:17 AM Reindl Harald wrote: > > > Am 16.10.19 um 10:23 schrieb Gordan Bobic: > > I don't know if it is recoverable but it sounds like you missed the step > > of always needing a full, clean shutdown between upgrades with > > innodb_fast_shutdown=0. Then you can delete ib

Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

Am 16.10.19 um 10:23 schrieb Gordan Bobic: > I don't know if it is recoverable but it sounds like you missed the step > of always needing a full, clean shutdown between upgrades with > innodb_fast_shutdown=0. Then you can delete ib_logfile*, and upgrade. always? how comes that i didn't need th

Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

Hello there, Bapt. > Hello, > > On Ubuntu 19.04, which uses packages mariadb-server 10.3.17 and > mysql-server 5.7.27, I noticed that if I wanted to switch from MySQL to > MariaDB, the database is corrupted and there is a complete data loss > even if I switch back to MySQL. > I noticed that if I

Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

I don't know if it is recoverable but it sounds like you missed the step of always needing a full, clean shutdown between upgrades with innodb_fast_shutdown=0. Then you can delete ib_logfile*, and upgrade. On Wed, 16 Oct 2019, 09:19 bapt x, wrote: > Hello, > > On Ubuntu 19.04, which uses package

[Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

Hello, On Ubuntu 19.04, which uses packages mariadb-server 10.3.17 and mysql-server 5.7.27, I noticed that if I wanted to switch from MySQL to MariaDB, the database is corrupted and there is a complete data loss even if I switch back to MySQL. In the previous version of Ubuntu, switching from MySQ