Changing the table prefix in an installed Wordpress

Changing the table prefix in an installed Wordpress. Otherwise an obvious task, but steps four and five can stump you.

For step five, the following SQL snippet may come in handy.

UPDATE new_prefix_usermeta SET meta_key = REPLACE(meta_key, "wp_", "new_prefix_");

There’s also a plugin available.

---

• September 10, 2009 at 9:59
  in Web development, About blogging, Delicious

There are 3 other entries posted on this day.