save/backup all the databases
mysqldump --user <username> --password=<password> --all-databases > </path/to/file>
save/backup a database
mysqldump --user <username> --password=<password> <database> > </path/to/file>
save/backup a database with compression
mysqldump --user <username> --password=<password> -C <database> > </path/to/file>
save/backup tables with compression
mysqldump --user <username> --password=<password> -C <database> <table1> <table2> > </path/to/file>
restore/import a backup (with mysql)
mysql -u<username> -p<password> <database> < </path/to/file>
copy database from local to remote mysql server
mysqldump --opt <database> | mysql --host=<removeServer> -C <database>
SyntaxHighlighter 
