MySQL tips and tricks

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…