Hi,
I have a question about this procedure to migrate from a server with rt3 to another new server with rt4.
This is my steps:
1. On Server “rt3” do a backup
mysqldump --default-character-set=binary rt3 -p > rt3.sql
2. On server “rt4”:
- Install RT via tar and execute all the proecss until ‘initialize-database’ command
- Import rt3.sql on new rt4 server
- Configure /opt/rt4/etc/RT_SiteConfig.pm with default variables:
Set($DatabaseUser , ‘rt_user’);
Set($DatabasePassword , ‘rt_pass’);
Set($DatabaseName, ‘rt4’);
-
Execute perl from rt4 binaries to db rt3:
perl /opt/rt4/etc/upgrade/upgrade-mysql-schema.pl rt3 root password > queries.sql
mysql -u root -ppassword rt3 < queries.sql
4. Change on /opt/rt4/etc/RT_SiteConfig.pm to rt3 configuration
- Execute:
rt-setup-database --dba root --prompt-for-dba-password --action upgrade
This is the correct steps?
I see that certain table don’t create. For example ‘CustomRoles’