Moving Database from Stand-alone Domain to Add-on Domain

[Lamar]

A client wants to change a domain from its own account to being an add-on domain of another domain. Funny, it's usually the other way around. No problem, mostly, as I have done this before. However, he just told me that he needs to move a database associated with the domain. What is the most painless method to move the database so that it serves the add-on? Databases are my most profound weakness.

[myusername]

You should be able to just go into phpmyadmin and use the export option. keep all the defaults, then select the option to "ave as a file" then just go to the new accounts phpmyadmin and upload the file.

[.:RAIS:.]

Additionally, as the move is from a different username, the script using the DB will need the new login info. Besure that the db user has permissions to the db.