I’ve to rename an user from foo to bar. So, first of all I use the appropriate script:
./change_username.sh foo bar
Then, since this user has some specific httpd options, I change all occurence of foo to bar in the virtual host template. Then I reload httpd configuration.
Unfortunateli with this solution all database still belongs to no-more existent user foo. And I do not understand how should I recover them. If I do the whole procedure to restore foo user, databases show up again in directadmin, otherwise they simply disappear.
I had tried to do:
VERBOSE=1 DBUSER="da_admin" DBPASS="da_adminpass" USERNAME="foo" NEWUSERNAME="bar" /usr/local/bin/php /usr/local/directadmin/scripts/change_database_username.php
But nothing changes. The command simply doesn’t give any output. I think it’s becouse I run it once foo doesn’t exists anymore.
Does exist a different solution from dump the database, erase them and restore them with the new user?