Tool to export Database

I am in the process of moving a site from another host, but having problems moving the database.

The old host doesn't use php myadmin or other admin tools, their built in one keeps timing out when I try and export the database.

Is there any tool, program or script that allows me to export a database so I can then import it to my new host.

Any help will be appreciated.

 

can't you ask your present host to supply you with database backups?

 

The easiest way is to ask your host as sawz said earlier.

If you have shell access then you can use MySQL's command line utility mysqldump.

If your host allow you to connect remotely then you can use any of the MySQL GUIs.

Or you can install your own copy of phpmyadmin and increase the execution time.

 

If you want to retrieve information from a database for backup or move its contents to another database, the program mysqldump proves to be quite convenient. It is installed at all login-hosts and can be used to generate sql-data from databases and tables.

To retrieve all information from a database:

mysqldump -u andersl_user -p andersl_database > databasefile.sql
         

Code (markup):

 

My current host is being awkward thats why I am changing to a more reliable host. I still have a ticket open with them and on average it takes them days to reply, so I would rather just do it myself if possible.

I don't have shell access so that option is out of the way.

I will give one of the MySQL GUI tools and see if I can do it that way

 

Setting up phpMyAdmin is very easy. You can try that too.

 

It's possible, though unlikely, that your old host allows remote access to the MySQL server. If so, you could run the mysqldump command from another mysql client to get the data off.