Mysql dump and restore it on remote machine

SourceHost

#mysqldump --opt --skip-lock-tables -umyuser -pmy-secret-password teamcity --extended-insert --routines --add-drop-table | mysql -ubackup -pbackup -hremotehost.myodmain.com teamcity

If you want to reset the root password

mysql --defaults-file=/etc/mysql/debian.cnf

update mysql.user set password=PASSWORD('password') where user='root';