[GMOD-devel] RE: Gmod-devel digest, Vol 1 #358 - 2 msgs

[Axelrod, N. <Nel...@tc...>]

Charles,

Here is a nice MySQL auto-backup utility that I've used before to create
daily, weekly, and monthly compressed backups of multiple databases.
It's fairly easy to configure to your needs -

http://sourceforge.net/projects/automysqlbackup/



-----Original Message-----
From: gmo...@li...
[mailto:gmo...@li...]=20
Sent: Tuesday, March 16, 2004 11:09 PM
To: gmo...@li...
Subject: Gmod-devel digest, Vol 1 #358 - 2 msgs

Send Gmod-devel mailing list submissions to
	gmo...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/gmod-devel
or, via email, send a message with subject or body 'help' to
	gmo...@li...

You can reach the person managing the list at
	gmo...@li...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Gmod-devel digest..."


Today's Topics:

   1. server backup of mysql (Charles Hauser)
   2. Re: [Gmod-schema] server backup of mysql (Ken Y. Clark)

--__--__--

Message: 1
From: Charles Hauser <ch...@du...>
To: GMOD schema <gmo...@li...>,
        gmo...@li...
Organization: Duke University
Date: 16 Mar 2004 15:07:02 -0500
Subject: [GMOD-devel] server backup of mysql

All,

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 independantly (not dumpall)

for postgres I can do this using:

 - globals
	pg_dumpall -U $PG_ADMIN -g > $PG_BACKUP_DIR/globals.sql

 - databases

for database in $(psql -l -t -d template1 -U $PG_ADMIN | cut -f1 -d'|')
; do
    if [ $database =3D "template0" ] ; then
        continue  # we cannot backup or restore this database
    fi
=20

    # actually dump the database to a pg_dump "custom" file format...
    syslog debug "Attempting to backup database $database."
    pg_dump -f $PG_BACKUP_DIR/$database.custom -Fc -U $PG_ADMIN
$database
    if [ $? !=3D 0 ] ; then
        syslog crit "CRITICAL Failed to backup database $database."
    else
        syslog info "Backed up database $database."
    fi
=20

done



I'm not as well versed re mysql, does any one have suggestions?

Charles

=09



--__--__--

Message: 2
Date: Tue, 16 Mar 2004 16:28:31 -0500
From: "Ken Y. Clark" <kc...@cs...>
To: GMOD schema <gmo...@li...>,
   gmo...@li...
Subject: [GMOD-devel] Re: [Gmod-schema] server backup of mysql

On Tue, Mar 16, 2004 at 03:07:02PM -0500, Charles Hauser wrote:
> All,
>=20
> 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 independantly (not dumpall)

You'll probably want to use MySQL's own "mysqldump" to do this.  There
are lots of options you can use, but, at its simplest, you can use it
to just dump plain text INSERT statements.  E.g., to dump the "foo"
database:

    $ mysqldump -uroot -pXXXXX foo > foo.sql

The "mysql" database contains all the users, permissions, etc.  I've
never restored this database from a backup, so you might investigate
if dumping via "mysqldump" is really the best way to go for backing
that up.

HTH,

ky



--__--__--

_______________________________________________
Gmod-devel mailing list
Gmo...@li...
https://lists.sourceforge.net/lists/listinfo/gmod-devel


End of Gmod-devel Digest