mysql -p <ispconfigdb> -e"UPDATE <ispconfigdb>.isp_isp_datenbank SET status = 'u' WHERE status = '';"
This query will update the field "status" in the isp_isp_datenbank and set it to "u" (for update) where it's empty.
/root/ispconfig/php/php -q /root/ispconfig/scripts/writeconf.php
This script will rewrite all the user config files.
I use this method on the isp_isp_user table when i change a template config, then run the script and all user configs are according to my new template config.
Haven't tried it on a the databank table yet, but looking at uninstall.php it seems to work the same, in there (uninstall.php) they set all those status fields in the tables to "d" (mostlikely for delete
) and then run the writeconf.php file.