My VPS is using MariaDB, and my MAMP is using mySQL. I regularly replace my MAMP database (and moodledata) with my server's backup, and I have never noticed any problem.
PHP 7.2.30, MariaDB 10.2.31 on my VPS, PHP Version 7.2.8 & MySQL 5.7.23 on my MAMP.
When I do move the database from VPS to MAMP, I always drop the mySQL tables first. Not sure if this makes any difference.
PHP 7.2.30, MariaDB 10.2.31 on my VPS, PHP Version 7.2.8 & MySQL 5.7.23 on my MAMP.
When I do move the database from VPS to MAMP, I always drop the mySQL tables first. Not sure if this makes any difference.