Title: Changing Table Prefix
Last modified: August 22, 2016

---

# Changing Table Prefix

 *  Resolved [greben99](https://wordpress.org/support/users/greben99/)
 * (@greben99)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/changing-table-prefix/)
 * Hey Guys,
 * I’m sure this is a unique situation, but when you change a website prefix it 
   remembers the old prefix. This happened because I copied our website into a different
   region and use a different prefix but wanted to keep all the data from the previous
   one. I had a dig through the code and got lost in the newsmanStorable class. 
   Couldn’t quite find the culprit. See Error below. Cheers.
 * WordPress database error Table ‘wp_br_something.bc_newsman_lst_customer’ doesn’t
   exist for query INSERT HIGH_PRIORITY IGNORE into \n\t\t\t\t\tbc_newsman_lst_customer(
   ts, ip, email, status, ucode, fields, bounceStatus)\n\t\t\t\t\tVALUES(‘2014-09-
   04 05:20:18′,’58.174.99.106′,’blah@blah’,’1′,’JNwQNN2RjQARPa6HmSjhqA’,'{\\”first-
   name\\”:\\”Blah\\”,\\”last-name\\”:\\”Blah\\”,\\”country\\”:\\”BR\\”,\\”state\\”:\\”
   26\\”,\\”city\\”:\\”Paulo Lopes\\”,\\”postcode\\”:\\”88490-000\\”}’,”); made 
   by newsmanAPI->__construct, call_user_method, newsmanAPI->ajAddEmail, newsmanSub-
   >save, referer: [https://www.blah.com.au](https://www.blah.com.au)
 * [https://wordpress.org/plugins/wpnewsman-newsletters/](https://wordpress.org/plugins/wpnewsman-newsletters/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [greben99](https://wordpress.org/support/users/greben99/)
 * (@greben99)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/changing-table-prefix/#post-5254107)
 * By website prefix I mean the database prefix so I changed ours from say ‘bc_’
   to ‘bt_’ but its still looking for the table ‘bc_newsman’
 *  [neocoder](https://wordpress.org/support/users/neocoder/)
 * (@neocoder)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/changing-table-prefix/#post-5254119)
 * Hi,
 * when you moving your website, it’s better to use some backup plugin like BackupBuddy
   or its free alternative – BackUp WordPress ( [http://wordpress.org/plugins/backupwordpress/](http://wordpress.org/plugins/backupwordpress/)).
   They automatically handle table prefix changes during database migration.
 * If you moved your website manually and managed to fix all other prefix issues
   you can fix the one you wrote about by changing the prefixes of the lists table
   names in the bt_newsman_lists table, tblSubscribers field.
 * Regards,
    Alex L.
 *  Thread Starter [greben99](https://wordpress.org/support/users/greben99/)
 * (@greben99)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/changing-table-prefix/#post-5254155)
 * Thanks Alex, that’s perfect!! I will use BackupBuddy next time.
 * For now I’ll just update the prefixes in the table!
 * Thanks for your quick response.
    Cheers, Chris

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Changing Table Prefix’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wpnewsman-newsletters_b5b4b0.svg)
 * [WPNewsman Lite](https://wordpress.org/plugins/wpnewsman-newsletters/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpnewsman-newsletters/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpnewsman-newsletters/)
 * [Active Topics](https://wordpress.org/support/plugin/wpnewsman-newsletters/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpnewsman-newsletters/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpnewsman-newsletters/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [greben99](https://wordpress.org/support/users/greben99/)
 * Last activity: [11 years, 9 months ago](https://wordpress.org/support/topic/changing-table-prefix/#post-5254155)
 * Status: resolved