MOVE/COPY entire MySQL database
Posted on 2008-10-02
Is there a way to move or copy an entire database, rather than just a table?
This would be across Cpanel hosting accounts, i have root access and MySQL access enabled.
I have myphpadmin and phpflashmyadmin
In myphpadmin, there's a database copy (structure+data) but i don't see how to copy it to another account.
For instance in the text field entry for Copy database to:
i would want to put newusername_dbname
but i get access denied. So that means i need to login somehow as root.
I can login as root in phpflashmyadmin(there's no copy database option), but i don't know how to login as root in phpmyadmin since it's launched from a given cpanel hosting account
i may just need to export and then import in the new account.
just seeing if there's a shortcut