"©®" <newskidsnews.au.org> wrote in message
news:sIOdnfFa8OWQ3GHenZ2dnUVZ8qOdnZ2dpipex.net...MySQL software provides a backup tool called 'mysqldump', which produces a> How would I go about "getting" my database and moving it to the new
backup file you can download with FTP, then upload to your new host and
restore it using the 'mysql' CLI. However, the question is what method is
available to you since you have your database on a web hosting service.
Often such services don't give you access to the command-line tools that
come with MySQL.
It is often the case that hosting providers give you access to a web-based
MySQL administration tool, usually phpmyadmin. This web-based tool also has
a backup facility, but I'm not sure it saves a dump that is compatible with
the mysqldump files. You may have to use phpmyadmin on the destination host
as well, to import the database.
The best answer depends on what tools are provided by each of your two