How to transfer a database from one server to another?

You can import and export databases using phpMyAdmin; link to it is in CPANEL next to MySQL Databases icon.