Have you checked out the /opt/otrs/scripts/backup.pl and /opt/otrs/scripts/ restore.pl scripts? These are both described at https://otrs.github.io/doc/manual/admin/stable/en/html/backup-and-restore.html .
When performing restore from the generated backup files, I usually find that it's necessary to drop/create the mysql otrs database. Otherwise, the restore will complain that the database already exists. On the production environment, generate a backup: sudo /opt/otrs/scripts/backup.pl -d /path/to/backup/folder On the test environment: 1. Copy the backup from the production system. 2. Drop/create the otrs database. WARNING: make sure you're on the dev environment. mysql -e "drop database otrs;" mysql -e "create database otrs;" 3. Restore the backup. /opt/otrs/scripts/restore.pl -b /path/to/backup/folder/YYY-MM-DD_hh-mm/ -d /opt/otrs/ 4. Verify the DB. su - otrs -c '$HOME/bin/otrs.CheckDB.pl' 5. Re-configure the otrs cron jobs. /opt/otrs/bin/Cron.sh restart otrs 6. To disable otrs user cron jobs, for testing or to avoid colliding with an existing production instance, disable the otrs crontab with '/opt/otrs/bin/Cron.sh stop otrs'. 7. Start the Scheduler. su - otrs -c '$HOME/bin/otrs.Scheduler.pl -a start' Hope this helps. Jay On Wed, Aug 12, 2015 at 1:00 PM, Leonardo Certuche < leonardo.certu...@itconsultores.com.co> wrote: > Hello, > > The way we have done that before is: > > on app: > tar --exclude=var/article --exclude=var/tmp -cvpzf ../otrs_app.tar.gz * > > on db: > mysqldump -u root -p otrs > otrs_db.sql > > And then restore both on your new environment, previous installation of > the product so all software requirements are already met. > > On 12 August 2015 at 14:53, Samuel Diniz Casimiro < > samuel.casim...@camara.leg.br> wrote: > >> Hi everyone! >> >> >> >> I’m using OTRS 4.0.11. >> >> >> >> Because of some company policies, I need to set up to environments, one >> for testing and another for production (operational). >> >> >> >> The problem is: How to export the required configuration data from test >> env. and deploy it into production env? >> >> >> >> I know I could copy and paste the ZZZAuto.pm file, but is that enough? Is >> there any database configuration data I should also take care? If so, how? >> >> >> >> I know I could use the provided backup.pl script, but I don’t want to >> backup/restore all the data, only the configuration data. Is there any way >> to do so? >> >> >> >> Thanks in advance, >> >> >> >> Samuel >> >> --------------------------------------------------------------------- >> OTRS mailing list: otrs - Webpage: http://otrs.org/ >> Archive: http://lists.otrs.org/pipermail/otrs >> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs >> > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs >
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
