The following way is only good for users with phpMyAdmin installed on their servers!

1. Login to your old control panel and go to PHPmyAdmin (if you are running Cpanel, it will be under MySQL, at the bottom).
2. Choose the database you want to move from the drop down list on the left.
3. After the page loads, click on the 'Export' tag at the top of the right page. Then 'Select All'. This will select all the tables in the database.
4. Finally, check the SQL extension type (should be default), check the Save To File box and put in the name you want this file to have.
5. Hit 'Go'. This will save the .sql file to your machine at home/office.
6. Upload the .sql file to that account on your new server.
7. Login to shell and put in:
'mysql -u dbname_user -p dbname_dbname < dbfile.sql
8. Hit enter and for the password put in the password of that database.

If you do not have shell access, you can use phpmyadmin to do the same, almost.

After downloading the file, login to your phpmyadmin panel on your new server, choose the database you want to populate (must have the same name as the one on your old server), click on the SQL tab and copy/paste the whole database into the text field. Then just hit 'Go'. If the database is large, it may take a while, so give it some time.

Thats really a nice stepwise discription ..its a question asked regularly.;

Your post will help many