Import/Export Users - MySQL
Hello guys, I'm upgrading to a new MySQL database.
I managed to export all the RDM database connections to RDM1
Now I wanted to know how do I export users because I have around 200 registered users.
Is there any "import\export" for registered users?
Or is there some way to do this?
Tks.
All Comments (5)
Hello,
We do have a Powershell cmdlet to create users, but for MySQL there may be an added difficulty as to the MySQL account permissions.
What type of datasource are you migrating from?
Best regards,
Maurice
Maurice,
I am migrating from a MySQL database to another MySQL.
Hello,
When keeping the same technology, its best to use the native tools. Is using a backup/import using MySQL tools an option?
Maurice
Maurice,
Previously I had a database in Azure and migrated to MySQL.
This migration occurred some problems that persist to this day; (Https://forum.devolutions.net/messages.aspx?TopicID=24884)
If I use the migration of the database, it will not help because it is already a problem.
So I chose to create a new database.
Hello,
I have found this to migrate the MySQL user accounts : http://www.uptimemadeeasy.com/linux/mysql-migrate-users-server-server/
As for the RDM users, we would need to work on a powershell script to import them. I will try to get this done quickly.
Best regards,
Maurice