Migrate existing multi-user data to anothher server
Posted: 27 Oct 2009, 17:05
Good day,
I am writing documentation for our new installation of Essential Project and I am trying to anticipate the correct procedure for migrating existing data (stored in MySQL) to both a new Protege server and MySQL server in the future.
My confusion stems from the process in which the database tables are created in the first place, by "converting" a pprj file to a Protege database. Since the metaproject is setup to still point to the pprj files, even though the data is stored on a MySQL server, I can only assume that the MySQL server details are stored somewhere in this file. If I move all of the pprj files to a different server and the database is also migrated to a different server, how can I modify the pprj files to reflect the new server location, database and table names, login credentials, etc?
Logically I would assume that if I just try to "convert" the pprj files again to the new server that the data from the old server would be lost. Am I correct in assuming this or will this in fact work (i.e. the data is also stored in the pprj files)?
Thanks for any light you can shed on this.
I am writing documentation for our new installation of Essential Project and I am trying to anticipate the correct procedure for migrating existing data (stored in MySQL) to both a new Protege server and MySQL server in the future.
My confusion stems from the process in which the database tables are created in the first place, by "converting" a pprj file to a Protege database. Since the metaproject is setup to still point to the pprj files, even though the data is stored on a MySQL server, I can only assume that the MySQL server details are stored somewhere in this file. If I move all of the pprj files to a different server and the database is also migrated to a different server, how can I modify the pprj files to reflect the new server location, database and table names, login credentials, etc?
Logically I would assume that if I just try to "convert" the pprj files again to the new server that the data from the old server would be lost. Am I correct in assuming this or will this in fact work (i.e. the data is also stored in the pprj files)?
Thanks for any light you can shed on this.