Click here to Skip to main content
Sign Up to vote bad
good
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 - 7:41
Bsa03284


3 solutions

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  
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  
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
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 449
1 Mahesh Bailwal 373
2 Maciej Los 255
3 CPallini 175
4 Rohan Leuva 175
0 Sergey Alexandrovich Kryukov 9,287
1 OriginalGriff 7,204
2 CPallini 3,923
3 Rohan Leuva 3,211
4 Maciej Los 2,713


Advertise | Privacy | Mobile
Web01 | 2.6.130516.1 | Last Updated 31 Jan 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid