Transfering a sql DB to a new host

I've never tried this before but i need to transfer a DB from one host to another. Can i just use the export/import feature? and do i need to change anything once i've moved it like the DB name etc?

 

You can safe a database like any other data.
If you use phpmyadmin you can safe it in different formats where all data and the structure will be exactly the same as in your old host.

The only problem could be that your new host has a limit on how many data you can insert in the database. Then you have to ask your host to add it.

 

Use mySQLAdmin - is fantastic!

 

if the database is small, yes you can use import/export.

for large databases, dump the whole database into a big .sql file, transfer that file and restore.