How to export my Drupal content?

Migrate to WordPress

All the data about your posts, pages, comments, users, forum threads,… in your Drupal site is stored in a database. Therefore, getting a full copy of your Drupal data is as easy as exporting the data of the Drupal database. The export is isually a .sql (or .mysql) text file with the set of CREATE TABLE and INSERT SQL statements that would allow you to recreate the database structure and content in another site.

There are two ways of getting this export file:

– From Outside Drupal, using any database export tool like phpmyadmin 
– From Within Drupal, using any of the available backup modules, e.g. Backup and Migrate

Let’s take a closer look at both options.

From outside: PHPMyAdmin

PHPMyAdmin is a free tool to manage MySQL databases (most likely, your Drupal is using a MySQL backend, if not check what database export tools are available for your system). PHPMyAdmin is available from your control panel. Once inside phpmyadmin, you just need to select the Drupal database on the left column (you may have several databases installed in your site, to know which one is actually storing the Drupal content you may want to check the settings.php file, usually located in the subdirectories sites/default or /sites/default/files of your Drupal installation; look for a line like this one $db_url = ‘mysql://username:password@localhost/databasename’).

After selecting the database just go the export tab and select the tables you’d like to export (all of them or only the core ones if you’re sure you want to aim for the core package).


From within: Backup and Migrate Module

An alternative option is to install a backup Drupal module like Backup and Migrate. Then, you can just log in Drupal and use the module menu to select the tables to export, the destination folder for the export file and so on as shown below (your options may vary depending on the version of Drupal and the module you’re running).


We hope you’ll find this information useful. If something is not clear or missing, please let us know and we will improve the explanation.

Posted in: Content export / import Antonio VillegasHow to export my Drupal content?