I have moved hosting provider, and I have had to move the database too. Here are the commands I used to shift the database from one server to another.
To export the database:
mysqldump -h DBSERVER -u DBUSER -p DBNAME > DBNAME.sql
Substituting DBSERVER with the hosts adddress, DBUSER with your MySQL username on the current server and [...]