How to backup my remote MySql database

[jackannarichart]

I am running CMS made Simple content management system for my website. I want to move my existing website to another hosting server. I need to backup my old CMS MySql database remotely. I don’t have PhpMyAdmin installed on hosting server. I know the database name, database username, and its password.
So how can I can backup remotely my old database from server to local machine? Thanks in advance

[magallo]

If you have localhost running on your pc, you could install phpmyadmin locally and connect it to your database with the info you have. At that point you could do anything you would do on the host server.
"Simply" create a new local site and install phpmyadmin. You will need to manually set the config file before launching.
Hope this helps.

[scooper]

There's also the (very handy) Adminer module

http://dev.cmsmadesimple.org/projects/dbadminer

which will install a copy of Adminer you can access in the CMS admin area and which will allow you to export your db.