Page History

...

1. Dump specific tables from source TeamCity database

   Code Block
   language bash
   mysqldump --no-tablespaces -u teamcity -p teamcity ids_group \ ids_group_entity_id \ project \ project_mapping \ user_blocks \ user_build_parameters \ user_build_types_order \ usergroup_notification_data \ usergroup_notification_events \ usergroup_roles \ usergroups \ usergroup_subgroups \ usergroup_users \ usergroup_watch_type \ user_notification_data \ user_notification_events \ user_projects_visibility \ user_property \ user_roles \ users \ user_watch_type \ vcs_username > teamcity.sql

   
   

2. Copy /<source-teamcity-data-dir>/config/roles-config.xml

3. Pack dump and configuration fail into archive

   Code Block
   language bash
   zip -r users-groups-roles.zip teamcity.sql roles-config.xml

   
   

4. Copy archive to target TeamCity instance <source-teamcity-host>

5. Unpack archive
   

   Code Block
   language bash
   unzip users-groups-roles.zip

   
   

6. Place roles-config.xml to /<target-teamcity-data-dir>/config/roles-config.xml

7. Restore specific tables (TeamCity and/or DB service stop is not required)

   Code Block
   language bash
   mysql -u teamcity -p teamcity < teamcity.sql

   
   

...