SnipSnipe

Posted by eric on Nov 05, 2007

Running this script will back up and zip all mysql databases.

#!/bin/sh
mysqldump --opt --all-databases | bzip2 -c > /var/backup/databasebackup-`date -I`.sql.bz2

mysql, sh, one-liner

Posted by boxfan on Nov 08, 2007

•

MySQL Mass Text/String Replace

UPDATE table_name SET COLUMN = REPLACE(COLUMN, 'old_text', 'new_text');

mysql

Please submit any bugs/features and report abuse. Thanks!