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:
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’).
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 How to export my Drupal content?