WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Renaming Table Prefixes in Database (3 posts)

  1. edahani
    Member
    Posted 1 year ago #

    Hello,

    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.

    Thanks

  2. Chandan Kumar
    Member
    Posted 1 year ago #

    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.

  3. edahani
    Member
    Posted 1 year ago #

    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 :)

Topic Closed

This topic has been closed to new replies.

About this Topic