While trying to upgrade Servoy 4 to 5, I have created a new repository_server called servoy5 in mysql.
Since all user/group info are stored in the repository, is there a way to migrate all the old user/groups along with their permissions into my new servoy5 database? Or do we have to just upgrade the existing repository rather than creating a new one?
Any advice would be much appreciated.
It looks like there’s a bunch of tables in the repository that deals with users and groups.
Thanks
if you export everything from you old repository and you check the export users
and then import it it should bring over the users of the groups that are used by that solution.
You could also duplicate the database in MySQL and upgrade that one to v5 (this way you can still go back to 4).
A quickie Google-search gave me this command to use via the commandline:
mysqladmin create DB_newname -u DB_user --password=DB_pass && \
mysqldump -u DB_user --password=DB_pass DB_oldname | mysql -u DB_user --password=DB_pass DB_newname
And yes, the \ has a return after it.
Don’t forget to replace the DB_* 's with the appropriate values.
If you already have the new database created (and empty) then you can skip the first line.
Hope this helps.
After I’ve let Servoy Upgrade the Servoy Repository from Servoy 4 to 5, it prevented my from importing any solutions.
It will say that the solution already exist and won’t allow me to import.
Any ideas why?
I think I even tried doing a clean import, and it still won’t let me do it.
Thanks
I guess you want to import in repository , not in developer ? Which is the error (from servoy_log.txt) that you receive ?