strapi-plugin-data-import-export v3.1.7
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
.