Linux.com posted an article about backing up MySQL data
Backing up files and directories is relatively easy; databases, however, have some special quirks that you need to address. Our examples use MySQL, but the same principles apply to PostgreSQL and other relational databases.Backing up MySQL data
This article is excerpted from O'Reilly's recently published book Linux System Administration .