SEO

permalink · #1 (**permalink**) 03-20-2008, 12:47 PM

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 mysql_fix_privilege_tables after importing the dumpfile. I am
confused here - Please help me!

Please help me!

********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************

permalink · #2 (**permalink**) 03-20-2008, 12:47 PM

On Wed, Mar 19, 2008 at 12:15 PM, Brown, Charles <CBrown@bmi.com> 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 included in the dump file created by mysqldump.

If you dump all databases, you're also dumping the mysql.user
table, which is where privileges and login information for the other
databases is stored. So as long as the MySQL versions are the same
(or comparable) on the original host and target host if you're using
password hashing, or if everything is in plain text, you should be
just fine.

> Please help me!

Hey, Charlie Brown, why's everybody always pickin' on you? ;-P

--
</Daniel P. Brown>
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Are user privileges included in MYSQLDUMP