WordPress on different server to Prestashop

  • Resolved NFWRo

    (@nfwro)


    4 years, 1 month ago

    I understand that if the databases are on different hosts, that I need to export the Prestashop database, import it into the WordPress database and then run the import using the WordPress credentials. My question is, once the import is done successfully, how do I go about removing the Prestashop data from the database to clean it up? I’m not an SQL whizz, when it’s imported, will there be a specific reference that will enable me to run a query to remove everthing “xxx”?

    Thank you

    The page I need help with: [log in to see the link]

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

    (@kerfred)

    You can DROP the PrestaShop tables with phpMyAdmin. Normally, you can easily identify these tables because they have not the same prefix as the WordPress ones.

    Thread Starter NFWRo

    (@nfwro)

    Excellent – thank you so much for such a quick reply.

    Thread Starter NFWRo

    (@nfwro)

    Hi there
    I have imported the Prestashop database tables into my WordPress database. I’ve changed the URL and database information to reflect the URL of the site into which I’m importing and the database host, name, username and password to that of the WordPress database. When I click Test Connection, the button flashes, but nothing else seems to happen. The Log still shows the logs from when I tried to import from the original Prestashop site, nothing since.
    I have tried deactivating and reactivating the plugin, before I did that, the database connection information kept reverting to the original site information too, that has stopped now.
    Can you give me any clue as to what I might be doing wrong? It seems so straightforward.

    Thanks

    Plugin Author Kerfred

    (@kerfred)

    Perhaps your WordPress session has expired. If this is the case, you just have to refresh the page.

    Thread Starter NFWRo

    (@nfwro)

    Thank you for replying so quickly. It looks like it was something like that – I have just got it to be responsive. It looks like I have a problem with my imported data, I don’t think all the tables were imported correctly, so now I’m trying to find out how to fix that!

    Thread Starter NFWRo

    (@nfwro)

    OK, I’ve dropped the imported tables and started again and I got the same Internal Server Error half way through the import from Prestashop database to the WordPress database. Can I send you the log file? It seems to fail on searching for the ps_product table which apparently doesn’t exist?

    Thread Starter NFWRo

    (@nfwro)

    Please ignore that last bit, the error log is not reporting what I’ve just done, the failure to find the ps_product table was an hour ago when I tried to import using the plugin. So I’m back to being unable to import the tables from the Prestashop to the WordPress database. How do I find out what it causing that?

    Plugin Author Kerfred

    (@kerfred)

    You can send it privately to us using https://www.fredericgilles.net/support/

    Thread Starter NFWRo

    (@nfwro)

    Hi
    Thank you, but my host has managed to import the SQL file successfully. At the moment, I am importing into a test site to see how it goes, I have some questions about the import itself, which didn’t quite do what I expected. Shall I start a new thread to cover those questions since it covers a different subject?

    Plugin Author Kerfred

    (@kerfred)

    Yes, you can.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘WordPress on different server to Prestashop’ is closed to new replies.