How to deploy my C# mysql application on another computer

Question

0.00/5 (No votes)

See more:

Hello everyone, If anyone can help me in my problem I would really appreciate that.

I have done a C# windows application with Mysql as a database. I have finished my application and made a setup project.
The problem is, I don't know how will I have my database available on the other computers? Should I install Mysql server on the computers?

I have installed my application on another computer, but it is showing "unknown database".

Thanks for your Support,

Posted 30-Jan-13 7:41am

Bsa03

Add a Solution

3 solutions

Solution 1

What's the problem? Database or RDBMS?

Database, if you need, is usually included in installation (you can include any file, as you know). RDBMS is more usually claimed as a prerequisite for your product. If you need to deploy it with your application, refer to MySql documentation.

Also, it would be useful to see here: http://bit.ly/Vo5KyZ[^].

—SA

Posted 30-Jan-13 7:47am

Sergey Alexandrovich Kryukov

Solution 3

Thanks Guys,

Jibesh, I actually understood the concept from your solution. I have used Mysql Workbench through which I exported my Database. I installed Mysql on the other computer and imported the Database, and it worked!

Thanks again...!

Posted 31-Jan-13 5:23am

Bsa03

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Jibesh · Accepted Answer · 2013-01-30T07:59:00

This is what I normally do when I want to deploy a database involved application.

1. Make a setup that includes all my application, MySQL setup, MySQL script to create database
2. when someone run the setup install the MySQL setup first and configure the user Id and pwd and other setting in MySQL-UI
3. Run the Utility Application that I developed which accepts the database server, Uid and password
4. using MySQL.Cmd execute the script which creates the database,table, stored procedure etc
5. Copy all other exes and configuration files to the local drive

thats all your done!!