dkanavis

mysql_user_export

Jan 7th, 2017
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. [root@shrew /lh/home/kanavis/tools]# ./mysql_user_export.pl --help
  2. Export mysql user accounts.
  3. Prints SQL commands (and just them) to stdout and warnings/errors to stderr
  4.  
  5. Usage: mysql_user_export [-h HOST] [-u USER] [-s SOCKET] [-P PORT] [-p [PSWD]]
  6. [-H HOST1:HOST2] [-U USERNAMES] [-E USERNAMES] [-X HOSTNAMES]
  7.  
  8. Database connection options:
  9. -h HOST connect to MySQL HOST (default: localhost)
  10. -u USER connect as USER (default: root)
  11. -s SOCKET connect to SOCKET (default: /tmp/mysql.sock)
  12. -P PORT connect using PORT (default: 3306)
  13. -p PASSWORD connect using PASSWORD (as argument or interactive)
  14.  
  15. Export options:
  16. -H HOST1:HOST2 translate all hosts HOST1 to HOST2
  17. pass multiple values via space character
  18. -U USERNAMES export only users from this list
  19. pass multiple values via space character
  20. -E USERNAMES don't export users from this list
  21. pass multiple values via space character
  22. -X HOSTNAMES don't export hosts from this list
  23. pass multiple values via space character
Advertisement
Add Comment
Please, Sign In to add comment