How to import/export Joomla?
Importing and exporting Joomla may come in handy in cases when you need a Joomla backup or simply need to move your website to another database.
Go to phpMyAdmin and choose your old database
Choose the table named jos_users if you are not using jos_modify in the left part of the list
Left click on the export button on the upper side of the tabs.
Choose SQL as the format of the database
Below the Structure menu choose ‘Drop Table’ and deselect ‘If not exists’.
Make sure the Save as File is on the base of the webpage.
Click on the ‘Go’ button and save to hard drive.
Now do the same for the data tables ‘jos_core_acl_aro” and “jos_core_acl_aro_map’
Go to your new database.
Move to jos_users and left click on the Import button.
Click the ‘Go’ button.
Do the same for additional tables.
Go to your website and make sure that the import went fine.
If you are having issues, refresh the backups and start from the beginning.
If you are using the Community Builder, make sure you synchronize your users by checking the path Components > Community Builder > Tools > Sync users.