C# 自动部署MYSQL,使用Mysql部署的c＃

Hi

(1)I had created a c# application with backend mysql.But I dont know how to deploy or create setup_file.And how should i use this application on another computer without installing mysql on that pc.

(2)where is Mysql Database files are stored??

are they in"C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\data\"

And if they r, then how to deploy them with your application.

I have basic knowledge of c# and Mysql..

Plssss Help Me,

Thanks and Regards,

Swapnil

解决方案

If your application uses MySql, then the PC you deploy to must have access to a MySQL server installation. This could be on their own machine, or an existing installation.

However, you should not include MySQL in your installation. There are a couple of reasons:

1) They may already have MySQL installed on the network. If so, then they will presumably want to use that version.

2) If they do have MySQL installed and you start proliferating server instances, you are going to annoy the heck out of the database administrator...

3) A single site installation of MySQL is a lot more likely to be backed up than a number of scattered version under user control.

4) MySql is quite complex for a "normal" user to install and administer - it is not a good idea!

5) It will destroy the primary advantage of using MySql over SqlCE or SQLite - multiuser access. If everyone installs their own copy of MySQL, then you will have multiple copies of your database, each used by a single person. This will cause some confusion, and (depending on how you wrote the original database) may take some considerable effort to combine into a single instance when the problem is realized.

Instead, give them a link to the download, and let them work out if they need it.