Migrate from MySQL to MariaDB (Ubuntu)



Migrate from MySQL to MariaDB (Ubuntu)

Migrate from MySQL to MariaDB (Ubuntu)

NOTES: https://codewithsusan.com/notes/migrate-mysql-to-mariadb

=== 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

=== 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

=== DESCRIPTION ===
Walk through of migrating from MySQL to MariaDB. Includes steps to backup MySQL, uninstall MySQL, install and secure MariaDB, and then import MySQL data.

=== RELATED VIDEOS ===
MySQL Command Line – Database and User Creation
https://youtu.be/a7QwmYUUBOE

Simple Command Line Text Editing with Nano
https://youtu.be/fIl8jAfqsbg

Comments are closed.