Loading…
Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!
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!

Tweet Share
Feedback form is now closed.
Video Stream


Register Now
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.
Speakers
avatar for Daniel Black

Daniel Black

Chief Innovation Officer, MariaDB Foundation
Daniel is a MariaDB all rounder. He started doing as a DBA, and then starting fixing the bugs. On the journey to continue these multi-perspectives of the same product, he found a niche at the MariaDB Foundation as their Chief Innovation Officer. There he continues to drive improvements... Read More →

Wednesday May 12, 2021 06:30 - 07:00 EDT
Room #2
  Management & Backup, Development, Tools, or Utilities