Moved Site to New Server – No Joy

  • Resolved Rich

    (@rpm765)


    2 years, 1 month ago

    We moved this site to a new server at HostGator today. WP Data Access does not see the correct database in this new install. It sees the WordPress database, but the database I use within WP Data Access for this site is a different database. On all the pages where the database should be displaying information, I get an error which says, “ERROR: Wrong arguments [schema name not found].”

    I attempted to add the correct database using the Add Remote Database process, but that was the wrong thing to do and now I can’t delete that entry.

    We’re running WP Data Access Premium, updated to the current version.

    If you need login information, send an email to rich at the domain ogaugerr.com.

    I love this plugin, but I’m lost on this new server and need a little help on this to get it up and running again.

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Rich,

    When you copy your WP Data Access tables from one site to another with an external tool, the schema names are not updated. There is a script to fix this issue. You can download it from here:

    https://wpdataaccess.com/docs/data-explorer-problems-and-solutions/transfer-to-other-wordpress-database/

    Or copy/paste the code into your Query Builder and run it interactively.

    Does this fix the issue?
    Peter

    Thread Starter Rich

    (@rpm765)

    I ran the query, but it didn’t work. I think the issue is that WP Data Access doesn’t see the correct database on the new server.

    This is what the phpMyAdmin screen looked like on the old server:

    No other database appeared there, even thought the old site was also a WordPress site.

    This is what I see on the new server:

    The new ogaugerr_3d_downloads database does not appear in WP Data Access. Only the ogaugerr_repository database shows up in WP Data Access. That is the main WordPresss database for the site.

    This is what I see in WP Data Access Explorer:

    That “rdb:” entry was an error on my part to try and add the downloads database. It is incorrect, but I don;t know how to get rid of it.

    I don’t know what to do here, Peter. If you need to log in and look at this yourself, give me a way to contact you privately and I’ll give you the login credentials.

    Thanks for your help.

    Thread Starter Rich

    (@rpm765)

    UPDATE: IT IS FIXED!

    It was a permissions issue. I did not have the appropriate permissions set on the database, so it was not appearing in the plugin. Once I discovered that and fixed it, everything returned to normal.

    Whew!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Moved Site to New Server – No Joy’ is closed to new replies.