Replication server setup for mysql using phpmyadmin Cpanel

Question

I am hosting my website on a shared server, with a mysql database which I can access it using phpmyadmin only. Can we setup replication mechanism to replicate my DB to my local server periodically?

something like periodically it should dump the data from my live server to my local server or atleast create a dump file.

Thanks,

Answer 1

You can use this URL: http://username:password@website:2082/getsqlbackup/website…database.gz to get a gzipped copy of your databse. username and password are as they say, and 2082 is whatever port you use.

You can use wget in a batch file to get it automatically.