Backup & Restore OTRS in Windows machine.

[Harikumar]

Hi Team,

Please help me by providing detailed steps for backing up OTRS files and mysql db in windows system.
In the Usermanual,backup process in Linux is only explained.Kindly explain the process and steps required for doing back up and restoring in Windows machine also.

Thanks in advance.
Harikumar.M

[crythias]

Overview:
Backup: filesystem + mysqldump.
Restore: Install same version, restore filesystem, restore database.

Don't take my word for it. Your system restore and backup methods are up to you and completely under your control. You should test this on another machine for the way it should work in your environment.

[Huwiseg]

Instead using extra Software, its easier, if you can handle it, using the tools of OTRS and MySQL.

Start a command line and enter your otrs mysql bin dir, like
cd "c:\"Program Files (x86)\OTRS\mysql\bin"

Dump Database:
mysqldump.exe -u otrs -p databasename > path\to\your\new\dump.sql

Restore Database:
mysql -u otrs -p --database=databasename < path\to\your\dump.sql