If I read this correctly you have several databases
cpg11d_albums
cpg11d_comments
cpg11d_usergroups
cpg11d_banned
cpg11d_config
cpg11d_users
cpg11d_categories
cpg11d_pictures
cpg11d_votes
Do the following:
1) In DirectAdmin create a user called cpg11d
2) In DirectAdmin log into the user cpg11d
3) In DirectAdmin create all the above databases choosing usernames and passwords as you go along.
4) Log into your server using SSH as root
5) type this (find -name "cpg11d_albums") on the commandline.
6) You should now know where your databases are located /var/lib/mysql or some other path. Go to that directory, type "ls -l" (without the "") and you should see a list of your databases.
7) copy the corresponding files to each directory (cpg11d_album* goed into the cpg11d_album directory)
8) type "chown -R mysql:mysql *" (without the "")
9) go into each individual database directory and type "chmod 660 *" (without the "")
10) you should be able to access the databases using the assigned (in step 3) usernames and passwords.
Regards,
Onno Vrijburg