Solved

Creating an installer package to install Application and MySQL automatically

Posted on 2010-08-13
12
272 Views
Last Modified: 2012-05-10
hi,
    I have written a VB application and it uses MySQL, I want to configure an installer which will automatically rollout MySQL, apply the required SQL code to create the database, tables and structure, then install my App - leaving the customer with a fully working solution.

Does anybody have any ideas?

Thanks
0
Comment
Question by:damianb123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +2
12 Comments
 
LVL 5

Expert Comment

by:almander
ID: 33431199
I would add something to your application to do this. As opposed to making it part of the installation process. Something like a Create new database procedure in your application that is executed when the application is first run.

To create the database I would execute a script that has all of your necessary commands in it.

If you want to install mysql automatically, more information about your environment is needed. But you should look for a MySQL bootstrap installation that matches your environment.
0
 
LVL 15

Expert Comment

by:gplana
ID: 33431209
You should create an installer using InstallShield or something similar. You should also include the MySQL installer if you want to install MySQL at the target machine.

For getting SQL sentences to create the databases, just use phpMyAdmin which has an option to export database to SQL commands. Save this to a text file, and execute this on the target MySQL to create the database with its contents.

Hope it helps.
0
 
LVL 5

Expert Comment

by:almander
ID: 33434047
No need for installshield unless you already have it, you could still use the installer in Visual studio. Depends on the version of visual studio you are using?
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 15

Expert Comment

by:gplana
ID: 33434093
I want just to note that some Visual Studio versions include some versions of InstallShield, like InstallShield Express.
0
 

Author Comment

by:damianb123
ID: 33434144
Hi, I'm using visual studio 2008 professional
0
 
LVL 6

Expert Comment

by:tikusbalap
ID: 33434960
0
 
LVL 3

Expert Comment

by:deepusreedhar
ID: 33456259
In VS 2008, you can create the installer and add MySQL as a pre-requisite. Then before the application installs, it will install the MySQL from the specified path. Either from the installation disc or by downloading from the manufacturer.
0
 

Author Comment

by:damianb123
ID: 33462275
Thanks deepusreedhar,
    Could you provide more information on where I can do this  and how within VS 2008?

Thanks
0
 
LVL 3

Expert Comment

by:deepusreedhar
ID: 33463595
Hope you know how to create a deployment project for your application in your solution.
then you can right click on the deployment project to get into the property page where you can find the prerequisites button. there you have the option to choose prerequisites and tick box for create installer package for them and options for downloading from website while installing or to install from CD or so. See the attached file,
property-page.JPG
prerequisites.JPG
0
 

Author Comment

by:damianb123
ID: 33463630
But when I check it doesn't give the option for MySQL, only SQL Server from Microsoft.  How can I add my own items into the pre-requisites?

Thanks
0
 
LVL 3

Accepted Solution

by:
deepusreedhar earned 500 total points
ID: 33465402
0
 

Author Closing Comment

by:damianb123
ID: 33594168
Perfect, this worked great!

Thanks
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Slow MySQL (InnoDB) Query with Inner Join & GroupBy 7 67
Complex MySQL Query 2 39
MYSQL responding very slow 3 50
WordPress  Failed to Import Media 6 10
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question