Exporting User Data can have several advantages for Members that have multiple Sites or simply want to add more fields, some benefits can be:
- Export and then Import users from one site to another
- Export users and add additional columns with new options for each client (Badge System, Experience, Cities Visited, Languages Spoken, Skills, etc..)
- Cleaning up or reorganizing users depending on column values
- Doing a user backup of the site
- Fixing possible typos or missing information from users
- And many other reasons to export user data...
For all of this reasons doing a proper Export can save you time, work and offer a great level of safety for all your users.
With this in mind, the proper way of exporting all your users data is by following this steps:
1. On your Backend Dashboard, on the developer's tab, you will find a button for MySQL Database.
Click on it to access your personal PHPMyAdmin (A Web based MySQL Administrator).
2. Once in your PHPMyAdmin site, click on your respective site Database on the Left Website panel.
(The name of the database should include the Id of your site. For example, if my site ID is 1234, the name of the database should be something similar to mysite1234_directory)
3. Once the database unfolds and shows all the tables, proceed to the users_data table by scrolling down a bit on the left panel. Once you find the users_data table click on it.
4. After selecting the users_data table, on the center top section of the Page, you should see a button for Export. Click on it.
5. You should immediately see two options for Exporting, the Export Method and Format. The format by default and for exporting purposes should be SQL. Click on the GO button to start export of your users_data table which contains all your users information. Only if you wish to edit the information through applications like Excel, LibreOffice, etc.., should you export using the CSV format. Note that exporting your information through CSV will not work if you want to import the information immediately. You will need to modify the CSV to work correctly with the import feature of the BD site.
7. If you exported using the SQL format, you can import the users_data table again by simply selecting Import in the phpMyAdmin app (Same one you used for exporting), but before importing you will need to DROP the users_data table to avoid any problems). This will of course remove all members from that table, so be 100% sure you wish to proceed before doing this. Also make sure to follow this 3 things, first, make sure you have selected the database you wish to import to, second, make sure that the imported table has the same amount of columns than the users_data table you are importing to. Third and last, you need to drop or completely delete the current users_data table to avoid importing issues. Do this last step only after confirming the number of columns in the current users_data table is the same as the one you are importing. When importing, simply select the file you wish to import and select GO. If everything mentioned before was taken into consideration, your import should go without any problems.
NOTE: Like mentioned above, do not export using the CSV format if you wish to import the information right back to another site. Only if you wish to edit the information, should you export as CSV but taking into consideration that the information will not be easily imported and you need to edit the information and set the format of it to work with the importing system in the backend.