MySQL Notes
Backing up from the command line
$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]
Compressing backup
$ mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]
Restore from command line
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
Restoring compressed backup
gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]