Upgrade from MySQL to MariaDB
A mini-course showing how to upgrade from MySQL to MariaDB without losing your data and settings
Watch Introductory Video
The most recent version of XAMPP now includes MariaDB in place of MySQL. The upgrade from MySQL to MariaDB is straightforward, and the aim is that MariaDB should be a simple drop-in replacement for MySQL in existing projects. Nevertheless, it is still worth going through what's involved as there are a few steps which are not obvious to get it working nicely and it's important to take care to ensure that you do not lose your existing databases and that you keep any changes you have made to your settings.
Course Curriculum
Curriculum
Available in
days
days
after you enroll
-
Start01 Keep existing XAMPP settings, files, and data (1:27)
-
Start02 Back up MySQL databases using phpMyAdmin (1:28)
-
Start03 Back up MySQL databases using mysqldump (3:00)
-
Start04 Download and install XAMPP (2:38)
-
Start05 Restore settings from previous XAMPP installation (5:07)
-
Start06 Troubleshooting XAMPP installation (1) (2:54)
-
Start07 Troubleshooting XAMPP installation (2) (7:52)
-
Start08 Run myqsl_upgrade (1:05)
-
Start09 Upgrade to latest version of phpMyAdmin (3:04)
-
Start10 phpMyAdmin - Remove configuration storage message (0:56)
-
Start11 phpMyAdmin - set password for root user (2:43)
-
Start12 Restore databases from backups using phpMyAdmin (4:44)
-
Start13 Restore databases from backups using mysql command line (2:38)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own. In the unlikely event of Web in Action closing, I will give 6 months' notice to give you plenty of time to complete your courses.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.