12 Jan
2017
12 Jan
'17
18:01
On 12.01.2017 18:16, Dave Howorth wrote:
On Thu, 12 Jan 2017 14:55:45 +0100 Florian Gleixner <flo@redflo.de> wrote:
But mysqldump does not copy users, passwords and permissions.
Why do you say this? mysqldump will copy the mysql database containing the users and permissions, will it not?
mysqldump copies contents of user databases. You can try to copy the mysql database that contains users and permissions, but the schema may change from one mysql version to the next, so you may happen to break the mysql database and so make the rdbms unusable. I did never try this, i always copied user databases with mysqldump and always had to fix users and permissions.