SQLSTATE[HY000] [2006] MySQL server has gone away

  • Resolved mikeictinus

    (@mikeictinus)


    6 years, 11 months ago

    I have a local mamp installation and installed a test drupal site and a test wordpress site.

    Both sites work on my local machine with urls: localhost.com/drupal and localhost.com/wordpress. I am just using the default installations with no new content.

    I exported the drupal sql with prefix drupal_ into the wordpress database

    I run the plugin but the following appears

    === START import 2018-04-13 14:51:51 ===
    [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] [2006] MySQL server has gone away

    What is wrong? I triple checked the host credentials and don’t think the credentials are incorrect. I even tried to import from the test drupal site but get the same error.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter mikeictinus

    (@mikeictinus)

    I believe it now works if i put a prefix in front of each table in the drupal database.

    Plugin Author Kerfred

    (@kerfred)

    The prefix field must match the tables prefix in the Drupal database. It may be empty if there is no prefix.

    Thread Starter mikeictinus

    (@mikeictinus)

    Hello

    Sorry it still doesn’t work. I keep getting the error.

    I don’t have anything in URL of the live Drupal web site

    Hostname: localhost
    Port: 3306
    Database: Drupal (it has prefix drupal_)
    username: root
    Drupal Table prefix: drupal_

    Php: 7.0.22
    Mysql: 5.6.35

    === START test_database 2018-04-13 15:59:51 ===
    [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] [2006] MySQL server has gone away

    Plugin Author Kerfred

    (@kerfred)

    The message “MySQL server has gone away” means that the MySQL process has stopped. There may be something wrong with your MySQL installation.
    You can try with Ampps instead of MAMP.
    Please also double check the hostname and port fields.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQLSTATE[HY000] [2006] MySQL server has gone away’ is closed to new replies.