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 be

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,