Re: server backups

2004-03-19 Thread Keith Keller
On Fri, Mar 19, 2004 at 11:50:43AM -0500, Charles Hauser wrote: > > I'm interested in writing a cron job to backup mysql that will: > - Backup all the global information first (users and groups, typically) This information is in the mysql database; unlike postgres, there's no concept of ''global

server backups

2004-03-19 Thread Charles Hauser
All, I'm new to mysql. I'm interested in writing a cron job to backup mysql that will: - Backup all the global information first (users and groups, typically) - Backup each database independently (not dumpall) For postgres I can dump: - globals pg_dumpall -U $PG_ADMIN -g > $PG_BACK