List:General Discussion« Previous MessageNext Message »
From:Andre Hübner Date:February 20 2008 8:20am
Subject:external mysqldump
View as plain text  
Hi List,

i wrote this alrready in mysql-forum a few days ago, but did not get any 
answer. :(

i try to do backup with mysqldump from external host with routines.
mysqldump -R -h my.host.name -u myuser -p'mypass' mydb > filename.sql
I got error: myuser has insufficent privileges to SHOW CREATE FUNCTION 
`countuser`!
It works if i do the same mysqldumLine directly on the server where db is 
installed.
In mysql-table myuser has same privileges for % and locklhost. Are there 
some further restrictions for external connects?
I dont have an idea what to change now.

Thank you
Andre 

Thread
external mysqldumpAndre Hübner20 Feb
  • Re: external mysqldumpBen Clewett20 Feb
  • Re: external mysqldumpAndre Hübner20 Feb
    • Re: external mysqldumpBen Clewett20 Feb
  • Re: external mysqldumpAndre Hübner20 Feb
  • Re: external mysqldumpAndre Hübner20 Feb
    • Re: external mysqldumpSimon Elliston Ball20 Feb
  • Re: external mysqldumpAndre Hübner21 Feb