New install Servoy7 with MySQL Database

Classic Servoy
1

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

2

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):

[attachment=0]Screen Shot 2013-04-12 at 10.22.46 AM.png[/attachment]

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.

Screen Shot 2013-04-12 at 10.22.46 AM.png
Screen Shot 2013-04-12 at 10.22.46 AM.png823×542 33.1 KB

3

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 ```
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
4

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.
5

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

6

Just import them all :)