Migrate MySQL to MariaDB on Ubuntu 24.04
Migrating MySQL to MariaDB on Ubuntu 24.04 swaps out your database system to improve speed and gain extra storage options without breaking your current apps. MariaDB acts as a drop-in replacement for MySQL, meaning your tables and queries keep working normally after the switch.
Ubuntu 24.04 handles the change through its package manager by replacing the old database software while keeping all your existing data safe and intact.
Stop and uninstall MySQL using `systemctl stop mysql`, `apt-get remove`, and `deluser mysql`. Install MariaDB from its official repository using `apt install mariadb-server`. Restore your backed-up databases to complete the migration.
Backup current database
Backing up your current database before you migrate MySQL MariaDB keeps your data safe if anything goes wrong during the switch. You need to export all active databases and save a copy of your main configuration file to your home directory before you remove any software from Ubuntu.
Refer to the linked guide below for complete database export instructions.
Copy the active configuration file to the home directory as a safety net.
sudo cp /etc/mysql/my.cnf ~/my.cnf
Database exports finish securely before the next phase begins.
Verify MySQL and MariaDB compatibility
Compatibility checks confirm that the target MariaDB release supports all active database schemas and configurations.
Review the version matrix below before proceeding.
| MySQL | MariaDB |
| 5.1 | 5.1, 5.2, 5.3 |
| 5.5 | 5.5 |
| 5.6 | 10.0, 10.1 |
| 5.7 | 10.2, 10.3, 10.4, 10.5 |
| 8.0 | – |
Proceed to software removal once version alignment checks pass.
Stop and Uninstall MySQL from Ubuntu
Stopping and uninstalling MySQL from Ubuntu removes the old database software so it does not conflict with your new setup. You must halt active background processes and purge the old packages using the terminal before you install MariaDB on your system.
Execute the command below to terminate active MySQL processes.
sudo systemctl stop mysql
Purge the remaining software packages and associated user accounts from the system.
sudo apt-get remove mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
sudo deluser mysql
sudo rm -rf /var/lib/mysql
System cleanup completes successfully.
Install MariaDB
Installing MariaDB on Ubuntu 24.04 requires adding the official software repository and cryptographic keys to your system before you pull down the new packages. You need to configure the official source list in your terminal so your package manager downloads the correct version.
Navigate to the official repository configuration page.
Download the cryptographic GPG key (a secure digital signature that verifies software authenticity) for the repository, then create a new source file for MariaDB.
sudo apt install apt-transport-https curl
sudo mkdir -p /etc/apt/keyrings
sudo curl -o /etc/apt/keyrings/mariadb-keyring.pgp 'https://mariadb.org/mariadb_release_signing_key.pgp'
Write the repository definitions using the terminal editor.
sudo nano /etc/apt/sources.list.d/mariadb.sources
Populate the configuration block into the file.
# MariaDB 10.11 repository list - created 2025-03-21 17:45 UTC
# https://mariadb.org/download/
X-Repolib-Name: MariaDB
Types: deb
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# URIs: https://deb.mariadb.org/10.11/ubuntu
URIs: https://mirrors.accretive-networks.net/mariadb/repo/10.11/ubuntu
Suites: noble
Components: main main/debug
Signed-By: /etc/apt/keyrings/mariadb-keyring.pgp
Save the configuration changes and close the editor.
Refresh package indexes and deploy the database server.
sudo apt update
sudo apt install mariadb-server
Restore the previously preserved configuration file to the system path.
sudo cp ~/my.cnf /etc/mysql/
Start the database daemons and configure automatic startup routines.
sudo systemctl start mariadb
Import the archived database dumps back into the active server environment.
Follow the restoration tutorial below for database import instructions.
Restore the MariaDB database on Ubuntu
Following these procedures establishes a healthy database environment ready for production workloads.
Log into the SQL shell to verify database accessibility.
sudo mariadb
Deployment finishes successfully.
Conclusion:
Migrating database platforms on Ubuntu 24.04 yields long-term performance benefits when executed methodically.
- Backup Important Data: Always ensure you have a complete backup of your databases and configuration files before starting the migration.
- Compatibility Check: Verify the compatibility between your MySQL version and the MariaDB version to avoid potential issues.
- Uninstall MySQL: Completely remove MySQL from your system to prepare for the installation of MariaDB.
- Install MariaDB: Use the official repository to install the most recent version of MariaDB on your Ubuntu system.
- Restore Backups: After installation, restore your databases to the new MariaDB server to regain access to your data.
- Test Functionality: Once migrated, log into MariaDB and perform checks to ensure everything functions correctly.
System administrators gain a faster, robust database engine backed by active community development.
Was this guide helpful?
About the Author
Richard
Tech Writer, IT Professional
Richard, a writer for Geek Rewind, is a tech enthusiast who loves breaking down complex IT topics into simple, easy-to-understand ideas. With years of hands-on experience in system administration and enterprise IT operations, he’s developed a knack for offering practical tips and solutions. Richard aims to make technology more accessible and actionable. He's deeply committed to the Geek Rewind community, always ready to answer questions and engage in discussions.
No comments yet — be the first to share your thoughts!