Learning some Mysql
I get to wear my MySQL hat – so some commands more for my own reference:
All databases:
mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]
mysqldump -u sadmin -p pass21 Customers > custback.sql
Some databases:
mysqldump -u root -p pass21 –databases Customers Orders Comments > multibackup.sql
Compressing on the fly:
mysqldump –all-databases | gzip >databasebackup.sql.gz
02.Sep.08 
Randomness 
Comments Off