How to run MySql and MariaDB on same server
0
votes
1
answer
31
views
Background
-
I am using XAMPP, which has MariaDB on my Windows development machine. I cant remove this as I have a number of projects that depend and use this.
On my new project on AWS EC2, Windows Server, I have IIS and MySql installed.
Issue
-
1. When I try my DB modifications on the dev machine, they don't always transfer over. I have to tweak them.
2. To confirm that my DB is identical to the Production one, I would like to backup the DB on the real server and restore it on my machine. But this is even worse, too many changes ae required.
Question
-
How can I run both Maria and MySQL on my Dev machine?
- MariaDB needs to remain unaffected
- MySQL does not have to run with Apache, the Development IDE has its own webserver for debugging.
- They both need to be available. Some projects will use MySQL, others will use MariaDB. No project will use both simultaneously.
Note
-
I hadn't tried installing MySQL, as I didn't want MariaDB to break - which would affect other projects.
Asked by Rohit Gupta
(2126 rep)
Jul 6, 2025, 03:00 AM
Last activity: Jul 8, 2025, 06:14 AM
Last activity: Jul 8, 2025, 06:14 AM