FAQ

Migrate to WordPress

Content export / import

How do I export my Joomla content?

How do I export my Joomla content?

Migrate to WordPress

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:

– 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.

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.

phpmyadmin

From within: Backup module extension

An alternative option is to install a backup Joomla module/extension like the Akeeba backup extension.

akeeba

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.

akeeba

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.

SQL file imported without errors but I don’t see any new post in my WordPress site

SQL file imported without errors but I don't see any new post in my WordPress site

Migrate to WordPress

You followed these instructions to import the SQL file and no errors were reported during the import process (typically you’d see a green message saying something like “X commands were successfuly executed”). Still, when you refresh your WordPress site you don’t see any new post/page/… there.

wp_custom_prefixMost likely this is due one of the two following reasons:

  • You imported the file in the wrong database. This can only happen if you are using the “from outside” option to import the file and you didn’t check which database was hosting your WordPress site. So please get back to the import instructions and repeat the process.
  • Your WordPress installation is not using the standard WordPress prefix (“wp_”) and you forgot to tell us your prefix (maybe you didn’t even know) so you end up with two sets of WordPress tables: the ones your WordPress site is actually using and the ones created during the import which are blissfully ignored (as in the image on the left, the “wp_” ones are the tables generated during the migration, the rest are the WordPress tables in use). In this case, you’ll need to drop the “wp_” tables and we’ll need to rerun the migration process to generate a new SQL file that matches your custom prefix.

User pictures not showing up in WordPress

User pictures not showing up in WordPress

Migrate to WordPress

A big difference of WordPress wrt others CMSs like Drupal is the fact that WordPress does not allow users to upload/change their profile picture. The reason being that the profile picture of a user is not managed by WordPress itself. Instead, WordPress relies on the Gravatar (global avatar) service to retrieve and show the picture corresponding to a given user.

The benefit of gravatars is that you can share the same profile picture among most of the blogs, forums, … where you participate. The disadvantage is that you need to register in Gravatar and upload your picture to see it in your WordPress.

This is the reason why user migration from Drupal, Joomla and others to WordPress will not migrate the profile picture of each user to WordPress. If the migrated user is already registered in Gravatar (based on the email information) his/her picture will immediately appear in WordPress. If not, s/he will need to register and upload the picture there.

Of course, if migrating user pictures is a must for you, there are WordPress plug-ins that provide an alternative functionality. We can help you choose one and study the additional migration features you’ll need to use/initialize it.

Error importing a WordPress users file

Error importing a WordPress users file

Migrate to WordPress

By default, all WordPress content-related tables are dropped and recreated as part of the migration process, wiping out all the existing data, and thus, avoiding conflicts with any sample data entered by before the migration.

The same process cannot be employed when migrating users. Otherwise the migration would remove the admin user information entered when installing WordPress and you wouldn’t be able to log in your own site. This is why, the .sql script containing the users migration data adds the new users but respects the existing admin user in the WordPress site.

Nevertheless, the script assumes that the admin user (id = 1) is the only existing WordPress user. If there are other users please remove them before importing the file. Alternatively, you could provide us with a copy of your WordPress database and we could configure the migration to make sure it respects all existing content.

Why do all pages appear as menu items after the import?

Why do all pages appear as menu items after the import?

Migrate to WordPress

If no custom menu is defined, the default WordPress behaviour is to show all pages as menu items. Obviously, specially if your site has plenty of pages, this default approach may not work for you.

To remove this WordPress menu and create your own just go to Appearance->Menus and add your own menu.

How to export my Drupal content?

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).

phpmyadmin

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).

drupalbackup

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.

Steps to follow to get your WP site ready after getting your data

Steps to follow to get your WP site ready after getting your data

Migrate to WordPress

If you requested the Content Migration Service, you just got a .sql file with your new WordPress data ready to be imported. To make sure everything goes smoothly please follow these steps:

1 – [if you are using redirection rules] Install the redirection plug-in. Do not change any configuration option, just install it and activate it.  After, set the permalink variable for the site to  /%postname%/  in Settings -> Permalinks

2 – [if your migration includes a forum] Install the bbPress plug-in. Do not change any configuration option, just install it and activate it.

3 – Import the .sql file in the database that your WordPress site is using (some further instructions on this). IMPORTANT: remember that, unless explicitly agreed beforehand, importing the file will wipe out the existing information in your WordPress content-related tables. The rest of the tables will be respected (check with us if you have questions regarding which exact tables will be affected). If you contracted the user migration feature remember that all users except for the user with id=1 (i.e. the user created when installing wordpress) will be removed (read more on this). If you are surprised to see all pages appearing as menu items, read this. Remember that creating a backup of your database before applying any sql script on it (ours or any other) is always a good practice.

4 – Copy and paste all image files from the “/sites/default/files” folder (or the folder you’re using to store the media files, we can help you to locate the exact folder) in your Drupal site to the wp-content/uploads folder in WordPress. Respect the same subdirectory structure if any, i.e. a Drupal image file in “/sites/default/files/sub/X.png” should be moved to wp-content/uploads/sub/X.png

Importing a SQL file with your WordPress data

Importing a SQL file with your WordPress data

Migrate to WordPress

All the data about your posts, pages, comments, users, forum threads,… of your new WP site generated during the migration is stored in a SQL file.

Watching all your old posts, comments,… “magically” appear in your WordPress dashboard is as easy as importing the SQL file in your WordPress database.

There are two ways to import this file:

– (recommended) From Outside WordPress, using any database import tool like phpmyadmin 
– From Within WordPress, using one of the (few) available restore modules.

Let’s take a closer look at both options.

From outside: PHPMyAdmin

PHPMyAdmin is a free tool to manage MySQL databases (the only official database backend for WP). PHPMyAdmin is available from your control panel. Once inside phpmyadmin, you just need to select the WP database on the left column. If your site contains several databases and you´re not sure which one is the one WP is installed on, open wp-config.php and look for a sentencel like define(‘DB_NAME’, ‘this is the name of your database’);.

After selecting the database just go the import tab and select the SQL file to import.

admin-import

If the file is too large for your current phpmyadmin import limits read this complementary post: Importing large SQL files with phpMyAdmin

From within: Adminer plug-in

An alternative option is to install a WP plug-in that allows us to select and execute a SQL file from within the WP dashboard. For this my recommendation would be to install the Adminer plug-in (WordPress version of the Adminer tool, kind of a competitor of phpmyadmin (as the Adminer people say in their web page: “Replace phpMyAdmin by Adminer and you will get tidier user interface, better support for MySQL features, higher performance and more security.”).

Once installed, you’ll find the Adminer option under the Tools Menu. Once you click on it you’ll have the option to execute Adminer in a separate tab

adminer php mysql tool

and the Adminer interface will immediately pop up. As with phpmyadmin, you have the list of tables on the left. The right hand side show the data/structure of the selected table.

adminer3

In the upper left corner, you’ll see the two most important options, the DUMP button (to export the data of the database) and, the option we were looking for, SQL command (to execute a SQL sentence, possibly importing it from an external file). Upload here your file and Adminer will take care of executing all SQL commands in it.

import sql adminer

Another option would be to use a Backup&Restore plug-in (perhaps surprisingly, the number of plug-ins for doing backup largely outnumbers the number of plug-ins that can also restore the database from a backup file). Among the few plug-ins that offer a Restore feature we have WP-DB ManagerXcloner and UpdraftPlus  (my favourite one, BackWPup recently stopped offering the restore feature).

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.

Antonio VillegasFrequently Asked Questions – FAQ