mysqldump on other host – an example
Just so i do not forget it:
mysqldump -hservername –user=backupuser –password=backupuserpassword –verbose databasename > backupfile.dmp
notes:
-h<servername> has no space between the -h flag and the hostname. No idea how they came to that idea.
<backupuser> has to has loginrights from any host or from your host table (the usual local user will not work)
<backupuser> needs LOCK TABLE permission for that DB
–verbose makes your live much easier
