Import Local from local

  • Resolved serviceweb

    (@serviceweb)


    7 years, 7 months ago

    Hello,

    i need to import from PS 1.6.1 to WC (latest version). My website is on localhost and i create a new database and import backup for Prestashop in a separate database.

    If i insert the setting for connection on database local Prestashop i have Connection failed – === START test_database 2017-04-21 09:49:49 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    I use:

    Hostname: localhost
    Port: 3306
    User: root
    Psw: mypassowrd
    Db Name: pstowc
    Prefix: ps_

    And put of URL the URL of my live website.

    How can i work and start importing?

    Thanks

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

    (@kerfred)

    If the WordPress site is local and if the PrestaShop database is local too, it should connect well if your connection settings are correct.

    What is the full error message?

    Thread Starter serviceweb

    (@serviceweb)

    Hello and thankf for reply. Is is in the same local and info for connect is correct. My full message is:

    Connection Failed and on log have this:

    === START test_database 2017-04-21 09:49:49 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    Table ‘psimport.ps_product’ doesn’t exist
    === END test_database 2017-04-21 09:49:49 ===

    === START test_database 2017-04-21 09:49:59 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

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

    Please read the FAQ for the solution.
    === END test_database 2017-04-21 09:54:59 ===

    === START test_database 2017-04-21 09:57:18 ===
    === START save 2017-04-21 09:58:12 ===
    Settings saved
    === END save 2017-04-21 09:58:12 ===

    === START save 2017-04-21 09:59:41 ===
    Settings saved
    === END save 2017-04-21 09:59:41 ===

    === START test_database 2017-04-21 09:59:54 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

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

    Please read the FAQ for the solution.
    === END test_database 2017-04-21 10:02:18 ===

    === START import 2017-04-21 10:02:26 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    Table ‘psimport.ps_product’ doesn’t exist
    === END import 2017-04-21 10:02:26 ===

    === START save 2017-04-21 10:02:31 ===
    Settings saved
    === END save 2017-04-21 10:02:31 ===

    === START test_database 2017-04-21 10:02:42 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    Table ‘psimport.ps_product’ doesn’t exist
    === END test_database 2017-04-21 10:02:42 ===

    === START save 2017-04-21 10:02:49 ===
    Settings saved
    === END save 2017-04-21 10:02:49 ===

    === START test_database 2017-04-21 10:02:58 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    Table ‘psimport.ps_product’ doesn’t exist
    === END test_database 2017-04-21 10:02:58 ===

    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

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

    Please read the FAQ for the solution.
    === END test_database 2017-04-21 10:04:54 ===

    === START test_database 2017-04-21 10:05:38 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    SQLSTATE[HY000] [1130] Host ‘DESKTOP-MHS3VUO.lan’ is not allowed to connect to this MariaDB server

    Please read the FAQ for the solution.
    === END test_database 2017-04-21 10:05:38 ===

    === START save 2017-04-21 10:05:41 ===
    Settings saved
    === END save 2017-04-21 10:05:41 ===

    === START test_database 2017-04-21 10:05:48 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    SQLSTATE[HY000] [1130] Host ‘DESKTOP-MHS3VUO.lan’ is not allowed to connect to this MariaDB server

    Please read the FAQ for the solution.
    === END test_database 2017-04-21 10:05:48 ===

    === START test_database 2017-04-21 10:06:41 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    Table ‘psimport.ps_product’ doesn’t exist
    === END test_database 2017-04-21 10:06:41 ===

    === START save 2017-04-21 10:06:50 ===
    Settings saved
    === END save 2017-04-21 10:06:50 ===

    === START test_database 2017-04-21 10:07:00 ===
    === START save 2017-04-21 10:07:13 ===
    Settings saved
    === END save 2017-04-21 10:07:13 ===

    === START test_database 2017-04-21 10:07:21 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    Table ‘psimport.ps_product’ doesn’t exist
    === END test_database 2017-04-21 10:07:21 ===

    === START test_database 2017-04-21 10:08:01 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    SQLSTATE[HY000] [1130] Host ‘DESKTOP-MHS3VUO.lan’ is not allowed to connect to this MariaDB server

    Please read the FAQ for the solution.
    === END test_database 2017-04-21 10:08:01 ===

    === START save 2017-04-21 10:08:03 ===
    Settings saved
    === END save 2017-04-21 10:08:03 ===

    === START test_database 2017-04-21 10:08:13 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    SQLSTATE[HY000] [1130] Host ‘DESKTOP-MHS3VUO.lan’ is not allowed to connect to this MariaDB server

    Please read the FAQ for the solution.
    === END test_database 2017-04-21 10:08:13 ===

    === START test_database 2017-04-21 10:08:43 ===
    [ERROR] Couldn’t connect to the PrestaShop database. Please check your parameters. And be sure the WordPress server can access the PrestaShop database.

    SQLSTATE[HY000] [1130] Host ‘DESKTOP-MHS3VUO.lan’ is not allowed to connect to this MariaDB server

    Please read the FAQ for the solution.

    Plugin Author Kerfred

    (@kerfred)

    It tells that the table ‘psimport.ps_product’ doesn’t exist.
    Please check the table prefix.
    And check if the PrestaShop database that you have imported in local is complete.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Import Local from local’ is closed to new replies.