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