Reputation: 1762
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
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