开发者

Replication server setup for mysql using phpmyadmin Cpanel

开发者 https://www.devze.com 2023-03-10 09:21 出处:网络
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 p

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号