How to Backup and Restore Users

Ryan Lecha -

To export users you can use the following script:

clustrix_clone_users

Make sure the script is executable once you have downloaded it.

chmod 755 clustrix_clone_users

The script will get the grants for all users in a way that's ideal for backup and import purposes. For example:

./clustrix_clone_users -H myhost -u root >> user_dump.sql

This can then be imported into Clustrix like:

mysql -uroot -h <clustrix IP> < user_dump.sql

For more information on clustrix_clone_users, please see the README

 

Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    Ivan Di Giusto

    Links in this page are not working.

    Looking for a way to backup users and privileges.

  • 0
    Avatar
    Scott Sullivan

    Ivan,

    Thanks for pointing this out. I've updated the URLs above with the correct links.

Please sign in to leave a comment.
Powered by Zendesk