New install Servoy7 with MySQL Database

[wichmann]

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

[david]

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 (58.59 KiB) Viewed 6578 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.

[imre_tokai]

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

[david]

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.

[imre_tokai]

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

[david]

Just import them all