I want to setup a cron job in my development mac os x running running MAMP (mac apache mysql php) to mirror myql database from remote host, say mysql.somesite.com:3306, to my local server localhost:8889.
1) frequent is about every 1 hour.
2) mirror only one database "mydatabase" with all it's tables and data
consider that remote access from my local ip is granted. and username password is username and password