Results 1 to 2 of 2
  1. #1

    backup mysql user privileges

    hi,
    how do i backup mysql user privileges?

    this will only backup the databases:
    mysqldump --opt -u root -p --all-databases > data.sql

    i would like to backup mysql user privileges too.

  2. #2
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    9,072
    You have to backup the mysql database.

    mysqldump -u root -p mysql > mysql.sql

    ... although, --all-databases should do the same thing as well.
    RACK911 Labs | Penetration Testing | https://www.RACK911Labs.ca

    www.HostingSecList.com - Security Notices for the Hosting Community.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •