I've inherited a site that uses MySQL 5.0 and want to get a development version up and running with the existing data on my local (OS X) machine where I have MariaDB 10.2 but the compatibility tables are a bit hard to fathom, and don't include MySQL 5.0.
All I need is a copy of the MySQL data on the sever running locally so I can work with the "real" data, but it's unclear whether
mysqldump will work between the two.
I don't want to install MySQL on my local machine and have dev sites that use it now, so I don't want to downgrade my local MariaDB. I could update MySQL on the server, but I'd rather leave it for now (it's a live service).
How would you approach this?