0

I am continually getting the error in the title when trying to do a mysql dump as per below:

mysql -hlocal.xxxx.com -uxxx -pxxx xxx < xxx.sql

Looking around, I thought it may have been an iptable issue but I've since allowed the designated address of local.****.com to the iptable, it says:

Chain INPUT (policy ACCEPT) target prot opt source
destination ACCEPT all -- local.*****.com anywhere

Chain FORWARD (policy ACCEPT) target prot opt source
destination

Chain OUTPUT (policy ACCEPT) target prot opt source
destination

but am still getting the same error/issue. If anyone has some insight on what I could/should do to go about this it would be much appreciated!

Kara
  • 6,115
  • 16
  • 50
  • 57
ec3
  • 55
  • 1
  • 10
  • what are the other ways you connect outside of command line ? Or should I also ask, when you connect via command line with above without – Drew Aug 06 '15 at 18:59
  • do you administer this server or is it remote and out of your control? – Drew Aug 06 '15 at 19:02
  • it's remote - I was able to connect to the remote server though with my public ssh key so I think that parts been done right? also @Ugo or anyone else if you can edit the name out from hlocal that'd be great! – ec3 Aug 07 '15 at 15:57
  • you still can connect via ssh right? Anyway, I assume it is a rights issue. can you get in and do a `select user,host from mysql.user order by 1,2` – Drew Aug 07 '15 at 16:06
  • Hi Drew, thanks for your help! I'm not sure what I did differently but it went through this morning fine without errors it seems. – ec3 Aug 07 '15 at 17:45
  • awesome good luck Elisa – Drew Aug 07 '15 at 17:48

0 Answers0