Mysql backup

to dump all databases from remote host:
mysqldump -aAcQl --add-drop-table --default-character-set=danish -h 10.0.181.249 -p > dump_tir.sql

to import the dum to 'remote' host:
mysql --default-character-set=danish -h 127.0.0.1 -p < dump_tir.sql

change default charset if necessary

to dump any specific db:
mysqldump -acQl --add-drop-table --default-character-set=danish -h localhost -p sknet > dump_phpBB.sql