If you are talking a database of any size (if you have any tables over 5-10 megs), you should use shell access to export your entire database into a gzip file, and then use shell to import it again.
Much quicker than phpMyAdmin (which I do swear by).
However if it is small - use phpMyAdmin. Could not be easier to do!
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.