New install Servoy7 with MySQL Database

Questions and answers for all installation-related topics for Servoy products

New install Servoy7 with MySQL Database

Postby wichmann » Fri Apr 12, 2013 2:50 pm

Hello,

I would like to install Servoy 7 with the MySQL database. The PostgreeSQL should not at all be installed.
Basically works (Servoy installation without Postgre SQL, MySQL Database, JDBC driver), but how
I get the repository data and sample data built on MySQL?

Does anyone have a manual or instructions?

MAC OSX 10.8.3
Servoy 7.0.0
MYSQL 5.5.27

regards
Andreas
DataBit GmbH
Mühletobel
CH-9217 Neukirch an der Thur
wichmann
 
Posts: 23
Joined: Fri Apr 12, 2013 2:44 pm

Re: New install Servoy7 with MySQL Database

Postby david » Fri Apr 12, 2013 4:24 pm

You don't need a repository connection when using developer -- it is the replacement for the filesystem/workspace when running server.

For the examples, you need a connection called "udm". So create a database in MySQL and create a connection to that database. Should look something like this (with different names):

Screen Shot 2013-04-12 at 10.22.46 AM.png
Screen Shot 2013-04-12 at 10.22.46 AM.png (58.59 KiB) Viewed 5580 times


Now right-click "All Solutions" node and choose "Import Solution". The sample solutions are located in /Servoy/application_server/solutions/examples. You will get a dialogue asking if you want to import data as well, say yes.
David Workman, Kabootit

Image
Everything you need to build great apps with Servoy
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Re: New install Servoy7 with MySQL Database

Postby imre_tokai » Fri Apr 19, 2013 6:01 pm

Hello,

Can sy share MySQL script for default Servoy tables and their content, please?
Or to share it permanently for different DBs in Wiki? bug_db, example_data, log_server, pdf_forms, udm, user_data.
Got repository_server via
Code: Select all
servoy_server -upgradeRepository

than got bug_db with sample solution servoy_sample_bug_db.servoy.
How to create and fill further tables?

During installation, needed to pick connect to existing DB.
Work-around would be to do the default installation and than to export Postrgres DB to MySQL, but different version of Postgres server is running here, so don't want to risk a mess

Thanks
Imre Tokai, Software Engineer
iTech Professionals, Inc.
User avatar
imre_tokai
 
Posts: 33
Joined: Mon Mar 26, 2012 12:18 pm

Re: New install Servoy7 with MySQL Database

Postby david » Fri Apr 19, 2013 6:18 pm

Those other "default" database connections are really only there for the sample solutions that come with Servoy. You don't need them unless you are working with a particular sample solution.

If you want those databases in MySQL:

1. create a mysql database
2. create a connection to the new database with the name you want (ie "udm")
3. import a sample solution that uses that database connection and choose "import sample data" when that option comes up.
David Workman, Kabootit

Image
Everything you need to build great apps with Servoy
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Re: New install Servoy7 with MySQL Database

Postby imre_tokai » Fri Apr 19, 2013 6:56 pm

Thanks David,
For bug_db, was able to achive by importing servoy_sample_bug_db.servoy
How can example_data, log_server, pdf_forms, udm, user_data be created/imported? Through which sample solutions?

Thought about posting sql for various DBs to Wiki as generic, wide-accessible information.

Regards
Imre Tokai, Software Engineer
iTech Professionals, Inc.
User avatar
imre_tokai
 
Posts: 33
Joined: Mon Mar 26, 2012 12:18 pm

Re: New install Servoy7 with MySQL Database

Postby david » Fri Apr 19, 2013 8:41 pm

Just import them all :)
David Workman, Kabootit

Image
Everything you need to build great apps with Servoy
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.


Return to Installation

Who is online

Users browsing this forum: No registered users and 3 guests