Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [root@shrew /lh/home/kanavis/tools]# ./mysql_user_export.pl --help
- Export mysql user accounts.
- Prints SQL commands (and just them) to stdout and warnings/errors to stderr
- Usage: mysql_user_export [-h HOST] [-u USER] [-s SOCKET] [-P PORT] [-p [PSWD]]
- [-H HOST1:HOST2] [-U USERNAMES] [-E USERNAMES] [-X HOSTNAMES]
- Database connection options:
- -h HOST connect to MySQL HOST (default: localhost)
- -u USER connect as USER (default: root)
- -s SOCKET connect to SOCKET (default: /tmp/mysql.sock)
- -P PORT connect using PORT (default: 3306)
- -p PASSWORD connect using PASSWORD (as argument or interactive)
- Export options:
- -H HOST1:HOST2 translate all hosts HOST1 to HOST2
- pass multiple values via space character
- -U USERNAMES export only users from this list
- pass multiple values via space character
- -E USERNAMES don't export users from this list
- pass multiple values via space character
- -X HOSTNAMES don't export hosts from this list
- pass multiple values via space character
Advertisement
Add Comment
Please, Sign In to add comment