[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Which hardware for saving backups?



On Mon, Jun 11, 2007 at 01:52:52PM -0500, Ron Johnson wrote:
> 
> Since Moodle stores it's data in MySQL or PostgreSQL, you'll have to 
> backup the whole database.  I wouldn't recommend using rsync.
> 
That should not just be a recommendation.  When it comes to databases,
you *must* properly dump the database contents to a backup file.  With
Postgres something like pg_dump or pg_dumpall is what you want.  There
are tradeoffs to each, so be sure and read up on them.

The point is that just copying the on-disk database cluster is *not*
good enough, as it can result in a corrupted or inconsistent database.

Regards,

-Roberto

-- 
Roberto C. Sánchez
http://people.connexer.com/~roberto
http://www.connexer.com

Attachment: signature.asc
Description: Digital signature


Reply to: