DEV Community

Rafael Corrêa Gomes
Rafael Corrêa Gomes

Posted on • Edited on • Originally published at blog.rafaelcg.com

2 2

How to import and export admin users on Magento 2?

Your admin users data are on the tables admin_user and admin_passwords in your Magento 2 database, you can use these commands to export and then import in your second store:

Export

$ mysqldump -p --user=username dbname admin_user admin_passwords > myAdminUsers.sql
Enter fullscreen mode Exit fullscreen mode

Import

$ mysql -u username -p -D dbname < myAdminUsers.sql
Enter fullscreen mode Exit fullscreen mode

Important

If you use a database prefix, don't forget to use on these commands above.

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay