Скачать или смотреть How to Change MariaDB to MySQL in XAMPP

Disclaimer/Disclosure: Some of the content was synthetically produced using various Generative AI (artificial intelligence) tools; so, there may be inaccuracies or misleading information present in the video. Please consider this before relying on the content to make any decisions or take any actions etc. If you still have any concerns, please feel free to write them in a comment. Thank you.
---

Summary: Learn how to switch from MariaDB to MySQL in your XAMPP stack with this step-by-step guide. Detailed instructions to ensure a smooth transition.
---

Switching from MariaDB to MySQL in XAMPP can be a necessary step for developers who need to align their development environment with their production servers or take advantage of specific MySQL features. This guide provides a detailed guide on how to change MariaDB to MySQL in XAMPP.

Prerequisites
Before you start, ensure you have:

A basic understanding of XAMPP and database operations.

Backed up your existing databases to prevent data loss.

Steps to Change MariaDB to MySQL in XAMPP

Step 1: Backup Your Data

First and foremost, it's vital to back up your existing databases. This can be done using phpMyAdmin or the command line. For phpMyAdmin:

Open phpMyAdmin in your browser.

Select the database to export.

Click on the 'Export' tab and choose the appropriate options.

Download the backup file.

For the command line:

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Stop the Apache and MySQL Services in XAMPP

Open your XAMPP Control Panel and stop both the Apache and MySQL services to ensure they are not using the database files during the switch.

Step 3: Uninstall MariaDB

Navigate to the xampp\mysql folder in your XAMPP installation directory. Rename the mysql folder to mariadb_backup for safety.

Step 4: Download and Install MySQL

Download the desired version of MySQL from the official MySQL website. After downloading, extract the contents of the MySQL ZIP file to the xampp\ directory and rename the extracted folder to mysql.

Step 5: Configure MySQL

Open the my.ini file located in the xampp\mysql\bin directory with a text editor.

Update any instance of "MariaDB" to "MySQL" if present. Additionally, ensure that the datadir and basedir paths point to the new MySQL directory.

[[See Video to Reveal this Text or Code Snippet]]

Step 6: Initialize MySQL

Open a command prompt and navigate to the xampp\mysql\bin directory. Initialize the MySQL data directory by running:

[[See Video to Reveal this Text or Code Snippet]]

Step 7: Start MySQL Service

Go back to the XAMPP Control Panel and start the MySQL service. The MySQL server should start without issues.

Step 8: Restore Your Data

Once the MySQL server is running, restore your previously backed-up databases. Use phpMyAdmin or the MySQL command line for restoration.

Using the command line, restore the backup with:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

Changing from MariaDB to MySQL in XAMPP may seem daunting, but by following these steps, you can make the transition smoothly. Always remember to back up your data before making significant changes to your development environment.

By understanding these steps, you can ensure your development and production environments remain in sync, thus minimizing potential issues during deployments.