Monthly Archives: May 2012

MySQL tips and tricks

May 17, 2012

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 […]