Click here to Skip to main content
15,920,110 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i create a s/w , by C# (visual studio) , at backend mySql. i create exe file which i create in visual studio.
so my Question is-

a)if i install the exe file in other computer then i have to install Mysql workbrench on that computer ?

b)if yes then how can i install it?
Posted

No - or if you can, you have done something very wrong.
MySql is a server based system, so you really shouldn't install it at all - the user should, or you should use an existing instance.

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 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 a server based database over SqlCE or SQLite - multiuser access. If everyone installs their own copy, 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.
 
Share this answer
 
you can check if any MySQL server installed in the target computer.
If the server if not exists, then install it in your C# application.

For schema/database structure installation, you can use:
MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900