Are user privileges included in MYSQLDUMP

2008-03-19 Thread Brown, Charles
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 included in the dump file created by mysqldump. What is the function of

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