Piwigo.org

Ralf · 2023-03-30 20:24:59

Hi,

my provider now supports mysql8 and i would like to migrate my mysql5.7 piwigo database to mysql8.

Any advices what is the best way to to this?

Doing a backup of the mysql 5.7 database and restore this backup to the new mysql 8 database seems to be too simple.
Or is this the way to go: backup and just do a restore?

Any advices?

Ralf

erAck · 2023-03-31 16:40:28

Doesn't the provider also offer a migration? Anyway, if available I'd rather migrate to MariaDB 10.x instead of MySQL 8. And if it was just because MySQL 8 ties you into a vendor lock-in to the company I don't name anymore..

And yes, doing a database backup and restore to replicate should work, the Piwigo database, tables and indexes aren't too complicated.

Ralf · 2023-03-31 17:05:37

Hi,
erACK thanks for your reply.

Now i know what i do over the weekend :-)

Cheers
Ralf

erAck · 2023-03-31 19:49:10

Just to be clear, with database backup/restore I was referring mysqldump or an equivalent web frontend, not some shady half-hearted whatever export ;-)

Ralf · 2023-04-01 13:51:50

Yes - i have mysqldump in my mind :-)

Ralf · 2023-04-15 14:53:16

Yes, it was as easy as erAck suggested

Piwigo.org

Announcement

#1 2023-03-30 20:24:59

Migrate to MYSQL8

#2 2023-03-31 16:40:28

Re: Migrate to MYSQL8

#3 2023-03-31 17:05:37

Re: Migrate to MYSQL8

#4 2023-03-31 19:49:10

Re: Migrate to MYSQL8

#5 2023-04-01 13:51:50

Re: Migrate to MYSQL8

#6 2023-04-15 14:53:16

Re: Migrate to MYSQL8

Board footer