Page 1 of 1

MySqlDump.Backup() scripts all users

Posted: Tue 23 Oct 2012 14:51
by ikkie
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?

Re: MySqlDump.Backup() scripts all users

Posted: Thu 25 Oct 2012 12:38
by Pinturiccio
We will investigate the possibility to backup only users related to dumped database.

Re: MySqlDump.Backup() scripts all users

Posted: Wed 07 Aug 2013 15:04
by Pinturiccio
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.

Re: MySqlDump.Backup() scripts all users

Posted: Thu 08 Aug 2013 12:11
by Pinturiccio
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