MySQL username and database name problem

[akylas]

Hello,

I need to import big amount of MySQL databases with MySQL users through backup restore. All works fine, but there is a big problem.
Naming of these databases and users is from different source, not DirectAdmin compatible (no DA username_dbname and no username_mysqlusername).

Backup restoring is not working without DA compatible naming...
It is possible to import directly to MySQL server and to create users and etc. But I need that after importing, all DA users can manage their MySQL databases from DA (at least change passwords and delete databases).

Do it is possible to use in DA not native MySQL users and databases naming?
For example: MySQL user name: myusername and database username: mydatabase, without user_ prefix?

Thank you for any help.

 

[nobaloney]

You can probablly figure out how to use MySQL databases not in the DirectAdmin naming format, but it's not supported, and the space won't be measured by DirectAdmin.

So you'd probably be better off setting up the sites on DirectAdmin without restoring the backups, then creating the databases in DirectAdmin.

Then take standard MySQL backups and restore them through phpMyAdmin. This has been discussed previously on these forums.

Jeff