I want to use rsync to backup my machines, but am not sure exactly how to do the databases. Can I just rsync the dirs with all the database info, or do I have to export the databases and rsync the resulting text/zip file? I'd have to backup MySQL and PostgreSQL. Also, how would I restore the db from the backup if I can just rsync the files instead of exporting to a text file?
