Replication setup
Thanks Arjen, my first replicating setup is now working.
After the replication workshop I decided having a local slave would be a much better idea than nightly remote mysqldump backups followed by rsync.
Not only can I develop queries on actual data locally now, the nightly automated data transfer has been reduced substantially as well.



Comments
arjen:
Why not do both? That is, also do a (local) mysqldump backup. If you have an InnoDB-only setup, it even lock-free!