• Welcome to XF2 Addons

    You can purchase a Premium membership for only $35 per year, and this gives you access to download any or ALL of the over 400 add-ons developed for Xenforo 2.x. In addition, Premium members will get technical support. Once the Premium membership has expired you can continue to use the installed addons on your forum as long as you like.

Backup your database using mysqldump


Staff member
Create backup.sql using mysqldump

1) Create a directory called 'mysql_backups' using cPanel and File Manager. This will be located in the following folder:


2) Log into your web site terminal. This is very easy to do on a macOS because all you have to do is go to the Terminal and enter the following:

ssh -l root

The number is the IP address of your server.

3) Now enter the following command to create a backup.sql file, this will be the backup of your database:

mysqldump --opt --no-tablespaces -uroot database_name > /home/path/mysql_backups/backup.sql

Note: if your database collation is uft8mb4 you will need to use this command:

mysqldump --opt --no-tablespaces --default-character-set=utf8mb4 -uroot database_name > /home/path/mysql_backups/backup.sql
Restore backup.sql into new database

1) Using cPanel create a new database called 'new_database' or any name you want.

2) Log into your web site terminal.

3) Enter the following command to restore the backup.sql to your new database.

mysql new_database < /home/path/mysql_backups/backup.sql
Setting up a Cron Job in cPanel

1) Go to the Cron Jobs in cPanel.

2) Create a new Cron Job with the following settings:


Command: mysqldump --opt --no-tablespaces --default-character-set=utf8mb4 -u'username' -p'password' database_name > /home/path/mysql_backups/backup.sql

3) I suggest creating one for each day of the week with the following: