Auto-syncing your local database from a remote MySQL Server (Dreamhost)

no comments yet, post one now

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

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 localdatabasename

In 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
    - that gives your local router or PC a hostname you can always reference -
    and that is automatically updated when changed. After registering, offer this as a free service.
April 24, 2006 09:13 by

no comments yet, add yours below

Leave a comment