RE: Are user privileges included in MYSQLDUMP

2008-03-19 Thread Rolando Edwards
Yes. Just use --all-databases as mysqldump option and the 'mysql' schema is included. -Original Message- From: Brown, Charles [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 12:15 PM To: mysql@lists.mysql.com Subject: Are user privileges included in MYSQLDUMP Using mysqldump, I

Re: Are user privileges included in MYSQLDUMP

2008-03-19 Thread Daniel Brown
On Wed, Mar 19, 2008 at 12:15 PM, Brown, Charles <[EMAIL PROTECTED]> wrote: > Using mysqldump, I'm about to dump all databases and import to another > instance - new . My question is do I need to define all security and > users in the new mysql or the security definitions and privileges will >