WordPress.org

1. edahani
   Member
   Posted 8 months 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 8 months 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 8 months 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 :)

Reply

You must log in to post.