Fetch remote database

How to import a remote database easily from command prompt in Windows. Since we can access databases remotely, you can use mysqldump from your windows machine to fetch the remote database. From command line:

mysqldump -u USER --password=MYPASSWORD DATABASE_TO_DUMP -h HOST > backup.sql

Checking the slowest queries on the server:

SSH: mysqldumpslow -s c -t 10 /var/log/mysql/slow-query.log

Copying a database from one to another:

SSH: mysqldump -uerplite -p'password' --opt --compress erplite_erp | mysql -uerptest -p'password' erptest_erptest