strapi-plugin-import-export

Usage

For mysql DB. Assumes enviornment variables with the following names:

DATABASE_NAME
DATABASE_USERNAME
DATABASE_PASSWORD
DATABASE_HOST
DATABASE_PORT

Installation

# Install package
npm i strapi-plugin-data-import-export 

# Rebuild Strapi front-end
npm run build --clean 

To store dumped data you must create a folder named /dumps at the root of your Strapi directory

Required Strapi Permissions

Add the following code block to ${strapi-folder}/config/functions/bootstrap.js

module.exports = () => {
  registerPermissionActions();
};
const registerPermissionActions = () => {
    const actions = 
      {
        section: 'plugins',
        displayName: 'Write',
        uid: 'write',
        pluginName: 'data-import-export',
      };
  
    const { actionProvider } = strapi.admin.services.permission;
    actionProvider.register(actions);
}

After running Strapi via npm run develop In Settings > Administration Panel > Roles access to the plugin can be granted for each role (Super Admin has permission by default).

Under Settings > Users & Permissions Plugin > Roles > Public > Data-Import-Export check the boxes for export and import.

Usage

After following the steps above, the plugin can be found under Plugins > Data Import/Export.

The Import Data button imports from ${strapi-folder}/dumps/latest.dump.sql.

The Export Data to Strapi button dumps your DB to ${strapi-folder}/dumps/latest.dump.sql

The Export Data to File System button dumps your DB to ~/Downloads/${db-name}-latest.sql.