Welcome to Percona Live Online 2021
Online Open Source Database Conference
Back To Schedule
Wednesday, May 12 • 06:30 - 07:00
Logical mariadb-dump --system Migration [30min]

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

Ever had some intricate permission structure you needed to move from one database to a different version database? Ever looked at a mysqldump of user tables and mapped up columns to see how a user was actually defined? Ever had a heirarchy of roles to move from MySQL to MariaDB? and back?

Logical dumps of system tables with inserts aren't logical enough, that what CREATE USER/ROLE etc was for. MariaDB added a "mariadb-dump --system=all" to allow forwards, backwards and sideways between MySQL/MariaDB versions of all those global things that exist in the mysql database.

Let me show you how.

avatar for Daniel Black

Daniel Black

Chief Innovation Officer, MariaDB Foundation
After a reasonable amount of time doing development and IT security work, Daniel landed a DBA Consultant job and loved it.After writing a few too many bug fixes without a client to bill them to, he joined IBM to make MariaDB and MySQL scale on IBM POWER.The love for the community... Read More →

Wednesday May 12, 2021 06:30 - 07:00 EDT
Room #2