https://wiki.frotmail.nl/index.php?action=history&feed=atom&title=MySQL_Backup
MySQL Backup - Revision history
2026-05-12T16:59:54Z
Revision history for this page on the wiki
MediaWiki 1.45.3
https://wiki.frotmail.nl/index.php?title=MySQL_Backup&diff=77&oldid=prev
Eric: Created page with " #!/bin/bash USERNAME="root" PW="pass" BACKUPDIR=/crew/data/backup DBDIR=/crew/data/backup/DB MYSQLDIR=/var/lib/mysql rm $DBDIR/*.sql `mv $BACKUPDIR/sql.tar.gz $BACKUPDIR/sql.tar.gz.1` `mv $BACKUPDIR/sql.md5 $BACKUPDIR/sql.md5.1` for DB in $MYSQLDIR/*; do DB=`basename $DB` mysqldump -c -e -a -B $DB -u $USERNAME -p$PW > $DBDIR/$DB.sql echo "$DB is dumped..." done tar -zvcf $BACKUPDIR/sql.tar.gz $DBDIR 1> /dev/null rm $DBDIR/*.sql `/usr/bin/md5sum $BACKUPDI..."
2022-04-05T09:26:31Z
<p>Created page with " #!/bin/bash USERNAME="root" PW="pass" BACKUPDIR=/crew/data/backup DBDIR=/crew/data/backup/DB MYSQLDIR=/var/lib/mysql rm $DBDIR/*.sql `mv $BACKUPDIR/sql.tar.gz $BACKUPDIR/sql.tar.gz.1` `mv $BACKUPDIR/sql.md5 $BACKUPDIR/sql.md5.1` for DB in $MYSQLDIR/*; do DB=`basename $DB` mysqldump -c -e -a -B $DB -u $USERNAME -p$PW > $DBDIR/$DB.sql echo "$DB is dumped..." done tar -zvcf $BACKUPDIR/sql.tar.gz $DBDIR 1> /dev/null rm $DBDIR/*.sql `/usr/bin/md5sum $BACKUPDI..."</p>
<p><b>New page</b></p><div> #!/bin/bash<br />
USERNAME="root"<br />
PW="pass"<br />
BACKUPDIR=/crew/data/backup<br />
DBDIR=/crew/data/backup/DB<br />
MYSQLDIR=/var/lib/mysql<br />
rm $DBDIR/*.sql<br />
`mv $BACKUPDIR/sql.tar.gz $BACKUPDIR/sql.tar.gz.1`<br />
`mv $BACKUPDIR/sql.md5 $BACKUPDIR/sql.md5.1`<br />
for DB in $MYSQLDIR/*; do<br />
DB=`basename $DB`<br />
mysqldump -c -e -a -B $DB -u $USERNAME -p$PW > $DBDIR/$DB.sql<br />
echo "$DB is dumped..."<br />
done<br />
tar -zvcf $BACKUPDIR/sql.tar.gz $DBDIR 1> /dev/null<br />
rm $DBDIR/*.sql<br />
`/usr/bin/md5sum $BACKUPDIR/sql.tar.gz > $BACKUPDIR/sql.md5`</div>
Eric