Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
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 8:41am
Bsa03322
Rate this: bad
good
Please Sign up or sign in to vote.

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
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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!!
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

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...!
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 7,215
1 DamithSL 5,114
2 Maciej Los 4,866
3 Sergey Alexandrovich Kryukov 4,747
4 Kornfeld Eliyahu Peter 4,514


Advertise | Privacy | Mobile
Web04 | 2.8.141223.1 | Last Updated 31 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100