File Mover Blog

August 17, 2019

Connecting to a MySQL / MariaDB Database

Dear Users,

MySQL: The world’s most popular open source database.

MariaDB: One of the most popular database servers. Made by the original developers of MySQL. Guaranteed to stay open source.

We’ve added MySQL / MariaDB as Database Connection option. This connection option is now available for:

– Database Logging option (added in version v2019.8.17.0)
– SQL as Source option (added in version v2019.8.17.0)
– SQL as Destination option (added in version v2019.8.17.0)

We are using a database framework called FireDAC. When connecting to a database the framework needs a client library (driver) suited for the type of database it is trying to connect. This client library needs to be installed by the user of our File Mover, we don’t deliver any database client drivers. The database client library for x86 or x64 are not the same so be sure to check which version of LimagitoX you are using (x86 or x64).

If the framework doesn’t find the library files then it will popup a message like:

The message gives you an indication that some dll could not be found. In the MySQL / MariaDB connection error above it could no locate libmysql.dll. As previously mentioned, the dll’s you need are different for x86 and x64.

>This is what we did in order to connect successfully to a MySQL / MariaDB database in the x86 version of LimagitoX:

  1. We downloaded the zipped Binaries of version 10 (mariadb-10.4.7-win32.zip) @ https://downloads.mariadb.org/mariadb/10.4.7/#os_group=windows
  2. Unzipped the following file from the mariadb-10.4.7-win32\lib subfolder: libmariadb.dll
  3. Renamed it to libmysql.dll and moved the file to the 32 bit program folder of LimagitoX File Mover: C:\Program Files (x86)\LimagitoX File Mover

>This is what we did in order to connect successfully to a PostgreSQL database in the x64 version of LimagitoX:

  1. We downloaded the zipped Binaries of version 10 (mariadb-10.4.7-winx64.zip) @ https://downloads.mariadb.org/mariadb/10.4.7/#os_group=windows
  2. Unzipped the following files from the mariadb-10.4.7-winx64\lib subfolder: libmariadb.dll
  3. Renamed it to libmysql.dll and  moved the file to the 64bit program folder of LimagitoX File Mover: C:\Program Files\LimagitoX File Mover

Microsoft SQL Server vs. MySQL

Regards,

Limagito Team

By Limagito-Team SQL , Share:
SEARCH