I'm having no luck with sql-sync, there's two seemingly unrelated errors it's throwing at me which I'll detail below.
I've been successfully sql-sync'ing the same site to another server, so I'm pretty sure it's the remote server, not the local server, that is causing the problems. The remote server MySQL version is: 5.6.19-0ubuntu0.14.04.1 (Ubuntu)
1) Adding the
--create-db switch gives me:
ERROR 1044 (42000) at line 1: Access denied for user 'user'@'localhost' to database 'database'
2) Regardless of whether or not I use the
--create-db switch, I always get this:
ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: '��T'.