Support » Fixing WordPress » Renaming Table Prefixes in Database

  • Resolved edahani



    I have recently changed my hosting and therefore had to transfer all my existing files into the new one.

    I am using phpMyAdmin with database prefixed tables xx_ (set during the installation of WordPress)

    [Moderater note: Changed your table prefix to xx_, please don’t add database information from your wp-config here]

    My old database however has a prefixed of wp_.

    Now I realized the duplications but not sure how to rename/remove them. Some of the forms I have on my website not working bcos of this.

    Hope to get some help here as I tried contacting the freelancer who developed my website but he’s unreachable now.


Viewing 2 replies - 1 through 2 (of 2 total)
  • There is no need to install a fresh WordPress setup, please follow these steps:
    1. Upload all files to new server root directory
    2. Take your older database backup through phpmyadmin
    3. Import database backup to new server through phymyadmin
    4. Update your wp-config.php with latest database details

    If you want to change table prefix follow these steps:
    1. Rename your all table’s name (with new prefix) after importing backup
    2. Then change prefix in wp-config.php file.

    Note: Please keep full backup of your site before making any change.

    Hi Chandan,

    Thanks for the reply!

    However it didn’t work for me as when I imported, they became duplicate tables with 2 different prefixes. So my only solutions was to do a fresh install and use back the same prefix. And later change them to another one for security purposes.

    Now it’s working fine 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Renaming Table Prefixes in Database’ is closed to new replies.