MySQL

Muammar

Hi, I'm considering using MySQL in my next project so can you please tell me: 1. What is the lightest and most simple version to install and where to get it as I'm using it as a replacement for access to be accessed from a C# application. 2. How can I install it and configure it silently "like including a pre-configured response file in Oracle" Thank you.

We will either find a way, or make one! (\ /) (- .-) C(''')(''')

Muammar

Ok, I found the answers in the MySQL forum but I still need an advice from you old users of MySQL as this will be my first shot and I need to make it right so please tell me what would you consider for my case. "A light stand alone database only accessed through one application". Thank you.

We will either find a way, or make one! (\ /) (- .-) C(''')(''')

loyal ginger

Any version of MySQL is not heavy. I don't know how to silently install and configure it, though. MySQL is usually used in a multi-client environment. From your description you want to get access to it from just one application. And you want to install an instance of MySQL with each of your application. This may be overkill. There is another option for you, which is SQLite. If you don't have problem with the restrictions of some of the data types in SQLite, you can try it instead of using MySQL. It's equally easy to program using C# to get access to SQLite, and the setup can be completely silent.

Muammar

Thanks mate!

We will either find a way, or make one! (\ /) (- .-) C(''')(''')

dybs

I actually had a similar situation on a project I'm working on. I think SQLite limits the database to 2GB or so, and that was too restrictive for us, so we went with MySQL. As for the silent install/config, you can run the .msi installer with the "-s" option, and then run the MySQLInstanceConfig.exe utility to set up your instance. This can be called from the command line with a set of switches for your particular setup (see here[^] for the list of parameters). I just put all the commands in a small console utility that runs as a custom action in our installer. Dybs

The shout of progress is not "Eureka!" it's "Strange... that's not what i expected". - peterchen

Muammar

That was quite informative.. Thanks mate!

We will either find a way, or make one! (\ /) (- .-) C(''')(''')

loyal ginger

The information you offered here is quite useful to me. I was not aware of the 2GB size limit of SQLite databases. I will sure check that out. The way to silently install MySQL is also very helpful.

dybs

Looks like I was mistaken on the size limt (I must have been thinking of MSSQL Express). According to the SQLite documentation[^] the max page size for a database is 32K, and the max number of pages is (1024^3)-1, bringing the total database size to around 32 TB! Oops, my bad :) Sorry for the misinformation. Dybs

The shout of progress is not "Eureka!" it's "Strange... that's not what i expected". - peterchen

loyal ginger

Thanks for the info!