How to import and export admin users on Magento 2?
Published
•1 min readR
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.
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.
