I occasionally use HeidiSQL to transfer tables and data from my local development server to my remote production server. (I use Tools/Maintenance/SQL Export/Output to Server.)
Right now, both servers have MySQL installed. However, the latest version of Xampp will install only MariaDB, whereas my remote server has only MySQL available. (The remote server is "shared", so I can't install MariaDB on it.)
Hence, if I upgrade my local server to the latest Xampp version, I'll need to occasionally transfer tables and data from my local MariaDB database to the remote MySQL database. And vice versa.
Can HeidiSQL transfer tables and data back and forth between MariaDB and MySQL? I mean, is this technically possible? Has it been tested? Is there a special procedure that must be followed?
Thanks.