How to achieve a complete Joomla export content
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 usually 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 to export your Joomla content file:
– From Outside Joomla, using any database export tool like phpmyadmin
– From Within Joomla, using one of the available backups extensions, like the Akeeba backup extension
Let’s take a closer look at both options.
Export from outside Joomla: 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 to the ‘export’ tab and select the tables you’d like to export.
Export from within Joomla: 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 will find this information useful and that you will be able to easily export your Joomla content. 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?