Re: [cobalt-users] RaQ4 - ? Re: Upgrading MySQL w/ ChiliSoft ASP

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"Rick Ewart" <cobalt@xxxxxxxxx> wrote:
> Only recently have I started using MySQL, PHP and all that fun
> stuff. I am using raqbackup.sh and noticed that the script wasn't dumping
> the databases correctly. After some archive research, I see its because I
> have v. 3.22.32-1 of MySQL installed which doesn't support the -a (dump
all
> dbases option). The solution is to upgrade..

I'd recommend upgrading to 3.23.x, but it's *a* solution, not *the*
solution.  If your goal is to backup your DBs, another option is to add a
shell script to backup all of the databases.  You simply need to loop
through your MySQL data directory, check for directories and run mysqldump
against them.  The following snippet should get you started.  Adjust to
taste.

for DB in `ls -1 $MYSQL_DATA_DIR`
do
    if test -d $MYSQL_DATA_DIR/$DB
    then
        mysqldump <options> $DB | gzip > $DB.gz
    fi
done

I'm not as up to speed on the Chilisoft stuff as I'd like to be so I can't
help you with that.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/