Renaming an user and move his databases

Hi all,

I’ve to rename an user from foo to bar. So, first of all I use the appropriate script:

Code:

cd /usr/local/directadmin/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:

Code:

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?

Cheers,
Zag