Hi!
I have installed a program (Open Journal System) and has a database (MySQL 5.0.37) installed, modified in the platform from windows.
On the other hand I have another program (Geonetwork version 2.0.3), with another database (MySQL 5.0.22) installed, modified in the Linux platform (Ubuntu version 6.06).
My question is how they can join the two databases, so what you write on Open Journal System, auntomaticamente is stored in the database Geonetwork and vice versa, without being redundant.
It is possible to have a single database for both programs
____________________________________________________________________________________
¡Capacidad ilimitada de almacenamiento en tu correo!
No te preocupes más por el espacio de tu cuenta con Correo Yahoo!:
http://correo.yahoo.com.mx/
Hi Irma,
On Thu, 2008-04-17 at 14:08 -0700, irma ap wrote:
Hi!
I have installed a program (Open Journal System) and has a database (MySQL 5.0.37) installed, modified in the platform from windows.
On the other hand I have another program (Geonetwork version 2.0.3), with another database (MySQL 5.0.22) installed, modified in the Linux platform (Ubuntu version 6.06).
My question is how they can join the two databases, so what you write on Open Journal System, auntomaticamente is stored in the database Geonetwork and vice versa, without being redundant.
It is possible to have a single database for both programs
It should very well be possible for both your applications to share 1
database application. Make sure your databases use different schema
names.
Just dump the contents of the schema(s) in a file (of the database you
don't want to keep) and import them into the database that you want to
keep. Then change the connection settings in either GeoNetwork or Open
Journal System.
Since this has more to do with MySQL than GN or OJS, I advise you to use
the MySQL mailing list for more specific questions/answers.
Regards,
Roald
--
Roald de Wit
Software Engineer
roald.dewit@anonymised.com
Commercial Support for Open Source GIS Software
http://lisasoft.com/LISAsoft/SupportedProducts/
Hi Irma,
On Thu, 2008-04-17 at 14:08 -0700, irma ap wrote:
Hi!
I have installed a program (Open Journal System) and has a database (MySQL 5.0.37) installed, modified in the platform from windows.
On the other hand I have another program (Geonetwork version 2.0.3), with another database (MySQL 5.0.22) installed, modified in the Linux platform (Ubuntu version 6.06).
My question is how they can join the two databases, so what you write on Open Journal System, auntomaticamente is stored in the database Geonetwork and vice versa, without being redundant.
It is possible to have a single database for both programs
It should very well be possible for both your applications to share 1
database application. Make sure your databases use different schema
names.
Just dump the contents of the schema(s) in a file (of the database you
don't want to keep) and import them into the database that you want to
keep. Then change the connection settings in either GeoNetwork or Open
Journal System.
Since this has more to do with MySQL than GN or OJS, I advise you to use
the MySQL mailing list for more specific questions/answers.
Regards,
Roald
--
Roald de Wit
Software Engineer
roald.dewit@anonymised.com
Commercial Support for Open Source GIS Software
http://lisasoft.com/LISAsoft/SupportedProducts/