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?
MySqlDump.Backup() scripts all users
-
Pinturiccio
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: MySqlDump.Backup() scripts all users
We will investigate the possibility to backup only users related to dumped database.
-
Pinturiccio
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: MySqlDump.Backup() scripts all users
We have implemented the IncludeDatabaseUsersOnly property of MySqlDump to include only users that have privileges in specified database in backup file. We will post here when the corresponding build of dotConnect for MySQL is available for download.
-
Pinturiccio
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: MySqlDump.Backup() scripts all users
The new build of dotConnect for MySQL 7.7.301 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=27700
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=27700