Kevindra
Kevindra

Reputation: 1762

Replication server setup for mysql using phpmyadmin Cpanel

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,

Upvotes: 1

Views: 5951

Answers (1)

paulmorriss
paulmorriss

Reputation: 2615

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.

Upvotes: 2

Related Questions