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,
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.
精彩评论