MySqlDump.Backup() scripts all users
Posted: Tue 23 Oct 2012 14:51
When MySqlDump.Backup() is executed, ALL users and priviledges on that server instance are scripted, when I am expecting it to script only the database users.
Keep in mind that:
I'm using MySqlDump.Backup() to migrate a selected database from 1 machine to another.
I've set the MySqlConnection.Database value and the MySqlDump.Database value to the database name.
I've set the MySqlDump.ObjectTypes = MySqlDumpObjects.All
Is there no way to restrict the users and priviledges to the database users and priviledges?
Keep in mind that:
I'm using MySqlDump.Backup() to migrate a selected database from 1 machine to another.
I've set the MySqlConnection.Database value and the MySqlDump.Database value to the database name.
I've set the MySqlDump.ObjectTypes = MySqlDumpObjects.All
Is there no way to restrict the users and priviledges to the database users and priviledges?