The MySQL tips and tricks that you could use
Leave a comment
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