Migrating Mariadb 10.3 with Sequences: A Smooth Transition

• When you import the data back in, Mariadb will recognize the information and convert it back into a functioning sequence object.
• mysqldump will treat the sequence object like a table during the dump process.
• Even though sequences are objects now, thankfully, you can still use the familiar mysqldump tool to export and import them.

Here's how you can achieve this:

1. Identify your sequences: You can use the following command to see a list of all sequences in your database:

SHOW FULL TABLES WHERE table_type='SEQUENCE';

1. Exporting Sequences:

Here's an example command using mysqldump to export your database schema and data, including sequences:

mysqldump -u username -p databse_name > database_backup.sql

Replace the following:

• database_name with the actual name of your database
• password (entered when prompted) with your Mariadb password
• username with your Mariadb username

Once you have the backup file (e.g., database_backup.sql), you can import it using the mysql command-line client:

mysql -u username -p databse_name < database_backup.sql

Again, replace the placeholders with your specific credentials and database name.

1. MariaDB Backup Tool (mariadb-backup):

• Refer to the Mariadb documentation for specific instructions on using mariadb-backup.
• It's known to handle sequences correctly during backups.
• This is a command-line tool specifically designed for backing up and restoring Mariadb databases.

1. Manual Scripting:

• This method offers more granular control but requires a deeper understanding of Mariadb sequences and SQL scripting.
• You can use SQL statements like SHOW CREATE SEQUENCE to retrieve the sequence definition and then execute CREATE SEQUENCE with the retrieved information on the target system.
• This is a more advanced approach involving writing scripts to interact with Mariadb directly.

Choosing the right method depends on your specific needs and comfort level:

• Manual Scripting: Offers maximum control but requires more technical expertise.
• mariadb-backup: Dedicated tool designed for Mariadb backups, potentially offering better performance or additional features.
• mysqldump: Simple and familiar for those already using it for database backups.