CPHULK sync between servers

[benito]

It would be great to sync CPHULK whitelists and blacklists between cpanel servers.

[cPanelTristan]

Hello benito,

Until this feature has been considered, you could grab the existing cphulkd database and import it to the new machine.

To create a dump of the existing whitelist and blacklist tables in cphulkd database on the existing machine:

mysqldump --add-drop-table cphulkd whitelist blacklist > cphulkd.sql

To restore the tables to a new machine's cphulkd database, you would first need to grab the root MySQL password:

cat /root/.my.cnf

At that point, then copy the cphulkd.sql file to the new machine and run the following to restore the sql file:

mysql -u root -p cphulkd < /pathto/cphulkd.sql

When the command prompts for the password, simply enter the previously copied root MySQL password. For the /pathto/cphulkd.sql file, you would enter the path where you'd saved the cphulkd.sql file onto the new machine.

Thanks.