MySQL

From Admin-SIG

It appears that database dumps are the acceptable way to back up MySQL data. mysqldump is the typical text dumper, which creates .sql files that can be loaded to re-create the database.

There is another dump-like tool, that seems to dump in some sort of a more MySQL-specific binary format.

I still need to get a clear idea if there are any configuration files, outside of /etc, that I should be getting.

Backing up MySQL from database dumps

Here's my very simple command using mysqldump:

    !/bin/sh
    date=`date -I`
    mysqldump -u root -pRootPassword --all-databases | bzip2 -c > /var/tmp/mySQLdump.sql.bz2
    smbclient //WINDOZEFILESERVER/ShareFolder -U WorkgroupUserName -W WORKGROUP WorkgroupPassword \
        -c "cd backups/gumby; put /var/tmp/mySQLdump.sql.bz2 mySQL$date.sql.bz2"

Table Corruption