Migration keeps failing. Import SQL to WP?

  • Resolved alphabear1

    (@alphabear1)


    4 months ago

    Hey, first time using this plugin, but it seems to fail every time despite best efforts.

    We are migrating a very old Drupal site (unable to check the version, as we receive ‘error’ when trying to pull a status report… what a clunky CMS).

    The settings.PHP file was blank for port and prefix, but I was able to get access to the server to confirm the prefix (the same as the db and username prefix). We also allowed remote MySQL connections using the new hostname/IP. Yet connections still fail.

    The FAQ and support tickets say, ‘oh just manually import the Drupal DB to WP’. But we have some major concerns around that that I’m hoping you can help with:

    1. Would this not overwrite what is already in WP? We’ve built the new site and don’t want that data to be wiped out.
    2. I’ve exported and imported WP SQL DB’s before, there were specific steps to follow, configurations to take care of, items to check, etc… where can I find that information? Or, can you advise the steps required to do this.
    3. Is it that we import the Drupal DB to the WP MySQL instance, then what do we put into the plugin? What connection details? Would it still be the Drupal admin details, or something else?

    Thanks for creating this plugin. It is literally the only option for people who don’t want to dig around in the mud with code to try and free people from this archaic CMS.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Kerfred

    (@kerfred)

    1. It won’t overwrite the already existing data, except if you ask the plugin to do it by clicking on “Empty WordPress content” or by selecting the automatic removal checkbox.
      In any case, I strongly advise you to make a backup of the WordPress database before doing anything.
    2. You just have to export the whole Drupal database to a SQL file and import it on the same database as WordPress. You can do it with phpMyAdmin.
    3. If the Drupal tables are stored in the same database as WordPress, you must use the same settings that you can find in the WordPress wp-config.php file.
      The prefix and the port can be empty.
    Thread Starter alphabear1

    (@alphabear1)

    Thanks, we’ll try this in the next few days and report back

    Thread Starter alphabear1

    (@alphabear1)

    Hi there,

    I’ve been provided with two Drupal DB’s (NAME_drupal and NAME_responsive).

    I’ve imported the _drupal DB into a new WordPress DB via phpmyadmin, and then used the details in the WP-config file to make a connection.

    After selecting “Import”, the plugin then immediately finished successfully (never a good sign), with approximately zero data actually being imported.

    Any idea what could be going on here?

    Plugin Author Kerfred

    (@kerfred)

    What is written in the logs?

    Thread Starter alphabear1

    (@alphabear1)

    Here’s the export from the log file. It should be noted that this DB 100% contains all the relevant Drupal data:

    === START test_database 2024-11-27 22:10:08 ===
    Connected with success to the Drupal database
    Drupal data found:
    0 articles
    0 pages
    0 categories
    0 tags

    [WARNING] Your Drupal database contains users. You need the Premium version to import them.
    [WARNING] Your Drupal database contains comments. You need the Premium version to import them.
    [WARNING] Your Drupal database contains custom nodes. You need the Premium version to import them.
    [WARNING] Your Drupal database contains custom taxonomies. You need the Premium version to import them.
    [WARNING] Your Drupal database contains URL alias. You need the Premium version to import them.
    [WARNING] Your Drupal database contains navigation menus. You need the Premium version to import them.
    [WARNING] Your Drupal database contains node blocks. You need the Premium version and the NodeBlock add-on to import them.
    [WARNING] Your Drupal database contains YouTube media fields. You need the Premium version and the Media Provider add-on to import them.
    [WARNING] Your Drupal database contains field collections. You need the Premium version and the Field Collection add-on to import them.
    [WARNING] Your Drupal database contains webforms. You need the Premium version and the Webform add-on to import them.
    === END test_database 2024-11-27 22:10:08 ===

    Plugin Author Kerfred

    (@kerfred)

    As stated in your logs, your Drupal site contains 0 articles, 0 pages, 0 categories, 0 tags. So it is normal that nothing is imported.

    But it contains custom nodes and custom taxonomies. You need the Premium version to import them.

    https://www.fredericgilles.net/fg-drupal-to-wordpress/

    You also need some add-ons to import all your data.

    Thread Starter alphabear1

    (@alphabear1)

    Yep so, that’s not the case at all. I can (and have) verified that the data does exist in the Drupal DB (as mentioned in the previous message). I have followed every step as provided, including all of the FAQ and troubleshooting steps, yet neither local nor remote import seems to work.

    We are not interested in pulling in anything other than the Drupal posts, so we don’t need any extra services, or add-ons, etc, just the basic functionality of this plugin.

    Does this plugin no longer work?

    This support thread needs to be unmarked as “resolved” as there is a clear issue with the plugin.

    Plugin Author Kerfred

    (@kerfred)

    I don’t think it comes from the plugin. Because it founds 0 articles in your database.

    Could you please double check that your Drupal database contains “post” or “article” nodes?

    If you still have any issue, please provide your Drupal database in private by writing to https://www.fredericgilles.net/support/
    I’ll check. And if there is an issue, it will be fixed.

Viewing 8 replies - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.