Import Drupal using PHPMyAdmin

  • Resolved yitwail

    (@yitwail)


    8 years, 6 months ago

    This is rather similar to a topic that’s been resolved, but I need more detailed instructions. Because the drupal site is on a different server from the WP site, I have to export from PHPMyAdmin. Then, your instructions say,

    import this SQL file on the same database as WordPress

    I want to make sure I do this correctly. I have to import the file into the same database that WordPress uses, is that correct?

    Thanks

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

    (@kerfred)

    Yes this is correct.
    If Drupal and WordPress are not located on the same host, you need to export the Drupal database to a SQL file and import this SQL file to the WordPress database. You can do it with phpMyAdmin.

    Thank you !

    First I was getting this message by inputing drupal credentials: [ERROR] Couldn’t connect to the Drupal database. Please check your parameters. And be sure the WordPress server can access the Drupal database. SQLSTATE[HY000] [2002] No such file or directory

    Our drupal site (Acquia hosting) and wordpress site (Pantheon hosting) are on 2 different hosting providers so I exported the Drupal database to a SQL file and imported that file into the WordPress database. I then tried using the WordPress credentials for the plugin and I still get that error.

    Please help.

    Plugin Author Kerfred

    (@kerfred)

    Please double check the hostname field. It should work.

    Plugin Author Kerfred

    (@kerfred)

    Please have a look at the FAQ that gives the solution to your problem: https://www.fredericgilles.net/support/kb/faq.php?id=28

    This error happens when the host is set like localhost:/tmp/mysql5d.sock
    Instead, you must set the host to be localhost;unix_socket=/tmp/mysql5d.sock

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Import Drupal using PHPMyAdmin’ is closed to new replies.