Dumping a mysql database that is on a different host

Jan 8 2014 8:00 PM JAN 8 2014 8:00 PM
mysqldumpMySQL | Unix | Ubuntu | Linux | Terminal

Basically had an issue with phpmyadin and needed to get a decent dump of someones database. Problem is they setup restrictions on ip addresses so I had to be a bit creative. Most my normal tools such as SQL pro could not connect around all this (At lease to my best effort.)

 

mysqldump -h mysql.yourserver.com -u mysql_user -p database_name table_name