Server Migration: Database issue

  • Resolved Markthedude

    (@markthedude)


    10 years, 6 months ago

    Hello,

    I’m trying to move wordpress from one server to another.

    Everything has been smooth but I’ve run into an issue I haven’t had before.

    I’m downloading the MySql database from my old server via Cpanel and PHPmyAdmin.

    When I upload the database to my new server via phpmyadmin I’m getting a “Databse Connection Issue”.

    What I noticed is that my old database table names look like this; wp_tableposts, wp_tablelinks, etc.

    It’s adding “table” in the name.

    I don’t get why everything is being named this way and I think it’s the main reason for my errors. All my other transfers looked like this for naming; wp_posts, wp_links, etc.

    How to I change this so I can import the database on the new server?

    Thanks.

Viewing 1 replies (of 1 total)
  • Thread Starter Markthedude

    (@markthedude)

    10 years, 6 months ago

    I figured the issue out.

    I wasn’t copying over my wp-config.php file since I was just using the new one that was created when I installed wordpress on the new server.

    For whatever reason my old servers config file used:

    $table_prefix = ‘wp_table’;

    The fresh, new install of wordpress used:

    $table_prefix = ‘wp_’;

    What I did to fix my issue wasn’t just doing a simple delete of “table” from the string.

    Just to make sure everything worked I copied over the username and database details with passwords from the new config file and updated the old config file with those details and simply uploaded the newly edited old config.php file and bam, the database was recognized and the site is working.

    P.s, after uploading the edited config file I deleted/emptied the database via phpmyadmin and re-uploaded the database. The site didn’t render properly until I started from scratch on the database upload.

    I have spent 2 days trying to figure this stuff out and so I hope that my “guide” here helps someone in the future.

Viewing 1 replies (of 1 total)
  • The topic ‘Server Migration: Database issue’ is closed to new replies.