Page 1 of 1
How to backup my remote MySql database
Posted: Fri Apr 28, 2017 1:14 am
by 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
Re: How to backup my remote MySql database
Posted: Thu May 04, 2017 3:47 am
by 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.
Re: How to backup my remote MySql database
Posted: Thu May 04, 2017 8:08 am
by 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.