Hi,
what operations do i use with Mysql instead Berkeleydb?

Thanks.

Maurizio.

Hello Maurizio,

You can either use your development node as mysql server or you can have a common server for several development stations.

Local mysql server:
Install mysql-server (5.0) and mysql-client.

Check that mysqld is running (start script in /etc/init.d/mysql).

Create a mysql user, for example pwrp

> mysql
mysql> grant all privileges on *.* to pwrp@localhost

Create a RootVolumeConfig object in the directory volume and set
Database to Mysql and Server to pwrp@localhost.

Remote mysql server:
Install mysql-server (5.0) and mysql-client on the server node (here called myserver).
Allow remote access in /etc/mysql/my.cnf.

Check that mysqld is running (start script in /etc/init.d/mysql).

Create a user for remote access

> mysql
mysql> grant all privileges on *.* to pwrp@\"%\"

Create a RootVolumeConfig object in the directory volume and set
Database to Mysql and Server to pwrp@myserver.

Not that the function 'copy project' in the administrator is not yet implemented for mysql databases (you have to copy the mysql database manually).

/Claes

Post edited by: claes, at: 2008/07/03 16:15

Hi Claes,
i tried with the local server and works very well.

Thanks.

Maurizio

Hi,
i tried to configure Class Volumes with Mysql, but does'ent create the database.
Why?

Thanks

Maurizio

Hi,

We seem to have missed to add some code for the opening the mysql databases for classvolumes. We'll try fix that to the next release.

/Claes

Hello, i am trying to get my volume to use a mysql database server, to do so, i create my new project and then configure the volume, afterwards i change the database parameter to mysql instead of berkeley, but when i try to open it afterwards, i get an error message saying \"Database not found /usr/local/pwrp/bd2/src/db/voldb2.dms\" ; any help please