Brown, Charles schrieb:
Here is a follow-up question: 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.
i am not sure if mysqldump does include `mysql` database, but you will see if you look into it,
you should run mysql_fix_privilege_tables after importing `mysql` database and FLUSH PRIVILEGES; -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
