mysql backup

backup (tum dbler)

===================

mysqldump --opt --user=root --password --all-databases | bzip2 -c

> /backup/mysql.bak-$date.sql.bz2



backup (2 db)

================

mysqldump --database mail sugar2 > mailadnsugardb.sql -u root -p







restore

========

mysql --one-database mail < excreate_mail_db.sql -u root -p