Results 1 to 2 of 2
Thread: backup mysql user privileges
-
08-26-2007, 03:35 PM #1Newbie
- Join Date
- Jul 2006
- Posts
- 23
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.
-
08-26-2007, 03:45 PM #2Web Hosting Master
- 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.