Very often i’m in need of moving external database to my own pc, bored of ssh + mysqldump + tar -zcf + scp + mysql < file

And here goes, oneliner:

ssh user@server 'mysqldump -uUSER -pPASSWORD DATABASE_NAME | gzip' | gunzip | mysql5 -uUSER -pPASSWORD DATABASE_NAME