Skip to main content

How to import and export admin users on Magento 2?

Updated 1 min readMarkdown

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

Import

$ mysql -u username -p -D dbname < myAdminUsers.sql

Important

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

About the author

  • I work at LeSite as Technology Director, where I’m responsible for lead the technical team to building innovative products.

    My passion for building software and sharing knowledge brought me to speak in over 14 conferences and create 21 projects used for more than 20,000 developers in the world. Now, I’m focused on helping merchants bringing innovation and technology strategy to their e-commerce ecosystem using the Magento 2, Adobe Commerce, Shopify Plus and other platforms.

No comments yet. Be the first to comment.

More from this blog