Can HeidiSQL transfer tables and data back and forth between MariaDB and MySQL databases? (Using SQL Export)

[expired user #5816]'s profile image [expired user #5816] posted 9 years ago in Import/Export Permalink

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.

BubikolRamios's profile image BubikolRamios posted 9 years ago Permalink

I have transfered all stuff from local mysql to latest local maria db. No problems observed. Vice versa no problems also.

[expired user #5816]'s profile image [expired user #5816] posted 9 years ago Permalink

I tried it myself, and verified that you are right. Thanks.

Please login to leave a reply, or register at first.