Moving existing customer databases - rename issue
I've got a configuration issue I'm not sure how to deal with.
I'm moving some customers from a Plesk server to an ISPConfig server. So far I'm not having issues moving e-mail customers, web content, DNS settings, etc - it requires a lot of diligence and housekeeping, but it's doable.
The issue I now have to deal with is moving user databases. Very few of my Plesk users have databases, but those that do of course have CGI scripts that refer to them. If I create a database for my customer whose WebID is WEB1370, for example, the database that gets created is "web1370_u1". If the customer's CGI scripts refer to the database as "site1Members", then the customer will have to modify all of their CGIs to refer to the new database name.
Aside from creating the database outside of ISPConfig, does anyone have any pointers as to how I might manage this?