I was experimenting with different ways of changing database prefixes today (the plugin method would not work for me). Being the type of person who always tries to take the path of least resistance, I exported my database, opened it in an editor and did a “Find and Replace All” on “wp_”. I then edited wp-config to reflect the change, deleted the original database tables and imported my updated database. The only odd effect I suffered was having to re-apply my custom page templates, and the settings for one plugin.
This seems way too easy, so before I break my own arm by patting myself on the back, I thought I should seek wiser opinions…
Is anyone aware of any ill effects or possible insecurities that I may have introduced by doing it this way, as opposed to starting with a clean install?
- The topic ‘database prefix change’ is closed to new replies.