Migrate from MySQL to MariaDB (Ubuntu)

preview_player
Показать описание
How to migrate from MySQL to MariaDB databases. Includes steps to backup MySQL, uninstall MySQL, install and secure MariaDB, and then import MySQL data.

COMMON ISSUES:
ERROR 1273 (HY000) at line 24: Unknown collation: 'utf8mb4_0900_ai_ci'
Fix for this error shown at 6:44

ERROR 1050 (42S01) at line 925: Table 'user' already exists
Fix for this error shown at 8:08

=== NOTES ===

=== CHAPTERS ===
00:00 Intro
00:42 Backup MySQL databases
01:50 Uninstall MySQL
02:52 Install MariaDB
04:02 Secure MariaDB
06:24 Import backup
09:07 Checking imported data via mysql command prompt

=== RELATED VIDEOS ===
MySQL Command Line - Database and User Creation

Simple Command Line Text Editing with Nano

=== PRODUCTS I USE ===
(paid links)
  1. Susan B.
Рекомендации по теме
Migrate from MySQL 0:12:48

Migrate from MySQL to MariaDB (Ubuntu)

Migrate Mysql8 to 0:06:19

Migrate Mysql8 to MariaDB

MySQL : Migrating 0:01:34

MySQL : Migrating from MySQL to MariaDB

How to Migrate 0:11:32

How to Migrate from MySQL to MariaDB on Linux CentOS - MariaDB Admin Tutorial

Easy MySQL Database 0:09:41

Easy MySQL Database Migrations (No Downtime and No Data Dumps!!)

How to migrate 0:09:05

How to migrate from MySQL to MariaDB without tears Q&A - Sveta Smirnova - MariaDB Server Fest 20...

How to migrate 0:31:58

How to migrate from MySQL to MariaDB without tears - Sveta Smirnova - MariaDB Server Fest 2020

WordPress - How 0:14:27

WordPress - How to Migrate Websites from MySQL to MariaDB

Migration Journey To 0:33:28

Migration Journey To TiDB - Kabilesh PR - Mydbops MyWebinar 38

Databases: new Install 0:03:05

Databases: new Install and migrate from mysql to mariadb

Databases: How to 0:02:17

Databases: How to migrate from MySQL to MariaDB or Percona with minimum downtime?

How to Move 0:10:05

How to Move an Entire MySQL Database

How to Migrate 0:13:22

How to Migrate Mysql database to Microsoft SQL Server

How to migrate 0:06:47

How to migrate MySQL databases with dbForge Studio for MySQL

PostgreSQL vs MySQL 0:06:33

PostgreSQL vs MySQL

How to backup 0:04:36

How to backup and restore a MySQL (MariaDB) database in CentOs Linux

Migrate from MariaDB 0:10:10

Migrate from MariaDB to PlanetScale

Easily convert a 0:03:00

Easily convert a Microsoft Access database into a MySQL file (no coding!)

How to convert 0:06:01

How to convert Home Assistant database to MariaDB

Databases: What's the 0:01:23

Databases: What's the best way to migrate from mariadb to mysql on ubuntu 18.04

Azerothcore drops support 0:11:17

Azerothcore drops support for mariadb. Guide to migrate to mysql!

How to Check 0:09:36

How to Check and Upgrade Your MySQL Version Easily

How to migrate 0:05:51

How to migrate a MySQL on-prem database to AWS RDS

MySQL vs MongoDB 0:05:30

MySQL vs MongoDB

Комментарии
Автор

Thank you! This worked perfectly on ubuntu server 24.04

antsarcade
Автор

Thank you so much. Very clear explanation.

vpugliese
Автор

Interesting, but I am also confused. 'Mysql is an alias for the underlying mariadb'. If, as I am planning to do, migrate from shared hosting with MySQL to Caprover w/ Docker, which has Wordpress with MySQL and Mariadb for Moodle, then how will the command distinguish between the two databases?
Thanks.

barkingbandicoot
Автор

Hello
I successfully migrated from MySQL 8 to MariaDB with the exact method in your video but the hard way.
My server is in Digitalocean and hosts two WordPress websites with Nginx. After migration, I found that the website loading time was extremely slow compared to MySQL.
Why would this happen if the MariaDB is the improved version of MySQL?
I switched to mariadb because I have one more application that runs on mariadb but now I'm stuck with slow webpage loading. Can you recommend what to check in the server configuration to improve this?

CheamPhyruostech