Database Integration and Migration

This feature allows you to integrate and migrate all activity log data created by User Activity Log PRO plugin to another database. Store the logs on an external database and decrease your current database size.

This feature allows you to integrate and migrate all activity log data created by User Activity Log PRO plugin to another database.

User Activity Log PRO Plugin can be connected to external database. You can set up the plugin to store activity logs in an external database.

  • Store the logs on an external database.
  • Decrease your current database size.

Follow the details for how to store the activity logs of your website to an external database, using the User Activity Log PRO plugin:

  • Setting up an external database connection in the DB integration menu
  • The plugin to use the new external database to store the all activity log
  • Migrate the activity log from the current database to the new created external database.

1. Setting Up an External Database Connection for the User Activity Log PRO

How to set up an external database connection in the plugin:

  • Go to Dashboard » User Activity Log » DB Integration
  • In the second step the wizard specifies all the following in the respective placeholder:
    1. Database Username (Database username used to connect with the database)
    2. Database Password (Database password used to connect with the database)
    3. Database Hostname (Database hostname used to connect with database)
    4. Database Name (Database name where you want to store user activity log)
    5. Table prefix (Table prefix where you want to store user activity log.)
  • In the third step Click the Save & Changes to save the new external database.

2. At this second stage, the plugin is using the newly created external database. So any new logs will be saved in the new external database.

3. Migrate the Activity Log from the Database

User can migrate data from the current database to an external database and migrate data from an external database to the current database.

  • Migrating data from the current database to an external database :

This feature is used to decrease your current database size.

Even though the plugin is now using an external database for the activity log, the old activity log events are still stored in the WordPress database. To migrate the events to the new external database simply click on Migrate data from the current database to an external database button.

  • Migrating data from the external database to the current database

Even though the plugin is now using a current database for the activity log, the old activity log events are still stored in the external database. To migrate the events to the new current database simply click on Migrate data from an external database to current database button.