WordPress.org

Forums

Rename Multisite Table Prefixes (7 posts)

  1. jtrost
    Member
    Posted 4 years ago #

    I noticed that when I add a new site, it names the tables in this structure: wp_[site #]_[table name]

    How do I change the table names to wp_[site name]_[table name]? If you have a dozen or more sites within WordPress, the database table names become meaningless if you use the site number to identify tables.

  2. But you have an admin screen that shows you which ID number corresponds to which name.

    You can change the wp_ part, but not the numbering scheme.

    as a super admin, you won't be spending a lot of time in there.

  3. It's human meaningless. The same as user IDs are meaningless :) Your admin can be #1, #2 or #24321 :) Makes no diff from a user's perspective. All that matters is WP knows what's up.

  4. jtrost
    Member
    Posted 4 years ago #

    I know I can see the corresponding number on the WP admin screen, but it's inefficient to be constantly switching back and forth between the admin screen and the database to figure out which table I want to see. The ability to change id numbers to site names would be a nice feature.

  5. Why are you calling the tables like that? I'm curious because you may be taking the long way around a simple problem :)

  6. jtrost
    Member
    Posted 4 years ago #

    I'm doing a mass import of data into the posts tables. I use built in WP functions whenever I am retrieving data.

  7. Why not use the built in wordpress import tools?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.