Precompiled MariaDB

MariaDB Library

[http://www.mariadb.org]

MariaDB is a drop-in replacement for MySQL. I have recently switched to it and I am quite happy. I compile many different versions of MariaDB with MSVC. I wrote a simple batch script to ease this process. You typically need the MariaDB source code, Cygwin and Microsoft Visual Studio. The main reason for these builds is to subsequently compile Qt4 and Qt5 with MySQL support. I modify the build to exclude building a number of unnecessary for my purposes libraries as well as change the postfix of the libraries and generally create a structure that I can use across my software project with ease.

The binaries posted here are experimental and any comments would be welcome. Thanks to all the people who have helped me improve these scripts and send me comments.

If you are using these binaries link back to this page as I update the scripts and binaries often.

If you are looking for older builds, go to the Precompiled MariaDB (Past Builds) page.

Date: 11 April 2017
Source Code: http://downloads.mariadb.org/mariadb/5.5.54/
Batch Script: build-mariadb-5.5.54.bat
Patches: [patch]
- Modifications to the CMake files of MariaDB to add a “d” suffix to debug libraries. Also remove certain libraries from being built
Notes: The script only supports patching, build all and package all.


Compiler	Download	Size	Arch	Build	Link	Notes
MSVC 2017	mariadb-5.5.54-vs2017.7z [md5]	10.2 MB	x86 (32-bit) x64 (64-bit)	debug release	shared static	compiled against OpenSSL 1.0.2k
MSVC 2015	mariadb-5.5.54-vs2015.7z [md5]	10.2 MB	x86 (32-bit) x64 (64-bit)	debug release	shared static	compiled against OpenSSL 1.0.2k
MSVC 2013	mariadb-5.5.54-vs2013.7z [md5]	8.7 MB	x86 (32-bit) x64 (64-bit)	debug release	shared static	compiled against OpenSSL 1.0.2k
MSVC 2012	mariadb-5.5.54-vs2012.7z [md5]	8.6 MB	x86 (32-bit) x64 (64-bit)	debug release	shared static	compiled against OpenSSL 1.0.2k
MSVC 2010	mariadb-5.5.54-vs2010.7z [md5]	8.1 MB	x86 (32-bit) x64 (64-bit)	debug release	shared static	compiled against OpenSSL 1.0.2k
MSVC 2008	mariadb-5.5.54-vs2008.7z [md5]	8 MB	x86 (32-bit) x64 (64-bit)	debug release	shared static	compiled against OpenSSL 1.0.2k

Disclaimer

Downloads in this website are exclusively here for my own personal use and have not been properly tested or verified.

#1 | Written by Olivier FREIMAN about 11 years ago. Reply

Now that I have successfully managed to install mariadb client, my next challenge is to install/run MySQL++ and/or MySQL C++/connector.
I may end up using the one I succeed installing.

I’m not (yet) asking for help, since I must try myself to do it. Just touch wood for me (to give me luck). Any eventual piece of advice or warning.

Just now, I’m starting on MySQL++ since several mariadb people seemed to have had a hand on it. This library looked very neat, but it’s quite unclear whether what they call “template” is actually a MySQL prepared query, or just a local and powerful substitution (I believe it is the latter). When the lib will be installed, I’ll investigate more on this matter.

Sincerely yours

Olivier FREIMAN, Paris, France.

0
#2 | Written by Olivier FREIMAN about 11 years ago. Reply

Thank you.
Actually, my problem was not linked (so to say) to MariaDB, but more to my own mistake in using VS 2012:
– I installed the Win x64 version of MariaDB client, since I’m using Win7 x64.
– BUT when I installed VS 2012, I presumed (obviously wrongly) that my projects were by default in x64. Profile named Win32 means x32 project, which will definitely NOT link to an x64 library. However, the resulting error, is NOT informative at all.
– Someone on stackoverflow was kind enough to point this to me. Even when you know the problem, finding and setting dev to x64 is cumbersome and NOT intuitive at all. One would have thought that Microsoft would do everything possible to encourage the developers to go x64, but it turns out to be quite the opposite.
– When I set the dev to x64, within minutes, I was able to create and run several tests for almost all the library functions.

Anyways, many thanks for your answer. I will also investigate in static vs linking issues: choices/settings/ +/-.

Have a nice day

Olivier FREIMAN, Paris, France

0
#3 | Written by Olivier FREIMAN about 11 years ago. Reply

Since you seem quite efficient with VS 2012 AND MariaDB, I do have a wish for some help or tips from you regarding using the MariaDB client:
I’m re-learning C++ and want to write programs which access access MariaDB (or MySQL) databases. It first, using the MariaDB 1.0.0 client seemed trivial, but I have been living a nightmare since a week.
The issue seems not so much the MariaDB client software than my lack of knowledge of the finer options of VS 2012 (Pro, NOT Express).
I write 2 instructions (within main, with the right includes), which compile OK, but Fail at link: MYSQL *mysql; mysql = msql_init(NULL);
I do set the INCLUDE Directory path, the LIBRARY INCLUDE PATH, AND the Additional Dependencies which specify the DBmariaclient.lib.
It seems to be all that I can do, but I get the dreaded “error LNK2019: unresolved external symbol _mysql_init@4 referenced in function _wmain”.
I have been stuck there for several days. Quite obviously, you have not, if you succeeded in compiling the whole MariaDB DBMS, and not just the tiny client.
If you could be kind enough to tell me where I have been so stupid, I would greatly appreciate it.

And by the way, I’m also trying to integrate Qt5.

The reason: I’m trying to get away from MS lock, and going from C#+WinForm (for me a very easy to use and program combination) to C++ + Qt5 + Boost + MariaDB, a much more powerful flexible combination, working both under Windows AND Linux.

So, I still have a lot of work to do, but Programming is Fun !! (at least for me, and hopefully for you too)

Thanks in advance for your time.

Olivier

0
- #4 | Written by stathis about 11 years ago. Reply
  
  Olivier, if you are compiling a shared binary use libmysql.lib to link against, what you are using is for static linking, which is not the default on VS projects. Also, I am not entirely sure why your file is called mariaclient.lib, there is no such file in the binaries here.
  
  0

sigmoid

Precompiled MariaDB

MariaDB Library

Disclaimer

Leave a Comment