Trying to do a simple backup of the mysql db with mysqldump. Have logged onto the DH server (berlin) via ssh, and entering:
mysqldump --opt -u<dbusername> -p<dbpassword> -h<dbhostname> <dbname> > dump.sql
I get the following error (after several lines have been written to the output file):
mysqldump: Got error: 1045: Access denied for user 'dbusername'@'126.96.36.199/255.255.128.0' (using password: YES) when using LOCK TABLES
Have googled around + have tried omitting --opt and adding --skip-add-locks - still get the same error.
Any ideas / pointers much appreciated.