Import Virtual Server issue with MySQL database

1 post / 0 new
#1 Thu, 12/17/2009 - 15:49
itchibahn

Import Virtual Server issue with MySQL database

After importing a site, I've noticed, that it didn't enable MySQL login. So I tried to enable the "MySQL login enabled", it fails with

"Failed to modify server : A MySQL database called mysite or user called mysite already exists"

I'm assuming because of the database name is not same as the username. For example, the site name is "mysite.com" with username "mysite" with database name "mysite_jos". Is there way to fix this issue without backing up the database, delete MySQL user & database, enable MySQL login, restore database content, and reconfigure the scripts to point to new database name?

This seems to be problem for all virtuals to import with database name different than the username.