Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

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

WaveLength's profile image WaveLength posted 4 years ago in Import/Export

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 4 years ago

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

WaveLength's profile image WaveLength posted 4 years ago

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

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