All the data about your posts, pages, comments, users,… in your Joomla site is stored in a database. Therefore, getting a full copy of your Joomla data to get ready for your Joomla to WordPress migration is as easy as exporting the data of the Joomla 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 Joomla database on the left column.
After selecting the database just go the export tab and select the tables you’d like to export.
From within: Backup module extension
An alternative option is to install a backup Joomla module/extension like the Akeeba backup extension.
Then, you can just log in Joomla and use the Components menu to select the Akeeba backup. In the configuration menu, select ‘Full Site Backup’ in the ‘Backup type’ option. Then click on ‘Backup now’ to start the backup. Once the backup has finished, go to ‘Administer backup files’ to download the backup file to your computer.
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 do I export my Joomla content?