Rename Multisite Table Prefixes

  • 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.

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

  • 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.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    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.

    Thread Starter jtrost

    (@jtrost)

    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.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Why are you calling the tables like that? I’m curious because you may be taking the long way around a simple problem ??

    Thread Starter jtrost

    (@jtrost)

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

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Why not use the built in wordpress import tools?

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Rename Multisite Table Prefixes’ is closed to new replies.