While redesigning this blog (which I still havent finished), I thought it would be a good idea to setup an automatic synch; from my Live Typo database at Dreamhost – through to my local Windows machine. Setup as a daily cron, I now have all my Typo data fed through to my windows machine, including all the posts, and settings I add and change here on the live site.
My local Typo install runs on Apache with FastCGi and MySQL. The cronjob on dreamhost runs daily at 9pm (when im sure that my local machine is turned on) – and simply calls this mysqldump command.
mysqldump --add-drop-table remotedatabasename -h remotehostname -u
remoteusername -premotepassword | mysql -u localusername -plocalpassword
-h localhostname.no-ip.org localdatabasenameIn order for this command to work, you’ll also have to setup the following;
- Your local MySQL server must be configured to allow incoming connections from remote machines.
- The MySQL user on your local server to access the database, should be configured to allow login from a remote connection, or a specific IP (e.g. your Dreamhosts box, IP address or hostname)
- If you use a hardware firewall/router on your local machine, it must be configured to port forward on MySQL (usually port 3306) – to your local machine that has MySQL running.
- Unless your firewall or local machine has been issued with a static IP, your going to need to use a service like No-ip.com - that gives your local router or PC a hostname you can always reference - and that is automatically updated when changed. After registering, No-ip.com offer this as a free service.
