MySqlDump.Backup() scripts all users

MySqlDump.Backup() scripts all users

Postby ikkie » 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?
ikkie
 
Posts: 1
Joined: Tue 23 Oct 2012 14:40

Re: MySqlDump.Backup() scripts all users

Postby Pinturiccio » Thu 25 Oct 2012 12:38

We will investigate the possibility to backup only users related to dumped database.
Pinturiccio
Devart Team
 
Posts: 1935
Joined: Wed 02 Nov 2011 09:44

Re: MySqlDump.Backup() scripts all users

Postby Pinturiccio » Wed 07 Aug 2013 15:04

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: 1935
Joined: Wed 02 Nov 2011 09:44

Re: MySqlDump.Backup() scripts all users

Postby Pinturiccio » Thu 08 Aug 2013 12:11

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
Pinturiccio
Devart Team
 
Posts: 1935
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL