Hello everyone,

I hope you're doing well. I have a few questions about the backup and restore process in osTicket. I'm looking to understand how to properly back up both the database and configuration files, and later restore them. So after that I will transfer the backup to my local server via FTP for safekeeping.

Here are my specific questions:
Database Backup and Restore:
1 .What is the recommended method to back up the osTicket database?

  1. How do I restore the database from a backup?

Configuration Files Backup and Restore:

  1. Which configuration files should I include in my backup to ensure a smooth restore?

Server information
osTicket v1.18 version (724de45) — Up to date
Web Software Server Apache/2.4.57 (CentOS Stream) OpenSSL/3.0.7
MySQL version 8.0.34
PHP Version 8.2.9

Thank you in advance for your assistance!

Best regards,
Kevin

    kevinazua

    To backup the database the mysqldump command is recommended for the best backup possible. To restore the database you can easily import the dump file as it’s in MySQL's native format (they have examples listed in the link above). Cool thing about the mysqldump command is you can create a very simple cron job or scheduled task to dump the database nightly or whatever schedule you desire.

    To backup the actual files if you want everything to be able to restore completely as you had it then you’d want to backup the entire osTicket folder. If you only want the necessities then you simply need to backup the /path/to/osTicket/include/ost-config.php file. As long as you have the database and config file you can redownload the code as long as it’s the same version or higher.

    Cheers.

      Write a Reply...