Title: Server Migration: Database issue
Last modified: August 21, 2016

---

# Server Migration: Database issue

 *  Resolved [Markthedude](https://wordpress.org/support/users/markthedude/)
 * (@markthedude)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/server-migration-database-issue/)
 * 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](https://wordpress.org/support/users/markthedude/)
 * (@markthedude)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/server-migration-database-issue/#post-4228655)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 1 participant
 * Last reply from: [Markthedude](https://wordpress.org/support/users/markthedude/)
 * Last activity: [12 years, 7 months ago](https://wordpress.org/support/topic/server-migration-database-issue/#post-4228655)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics