Database names

  • Resolved StevenW123

    (@stevenw123)


    11 months, 1 week ago

    Hi,

    I have tables on my site that contain a lot of URLs. I need to change a considerable number of these URLs with a plugin but I’m struggling to identify what TablePress calls its entries in the WP database. What tables do I need to look for, please?

    Also, is there an URL replacement plugin you can recommend that works perfectly with TablePress, please? (I tried Better Find and Replace but that plugin only found a fraction of the the URLs that need changing so next I’ll be trying Better Search Replace.)

    Thanks,

    Steve

    • This topic was modified 11 months, 1 week ago by StevenW123.
Viewing 1 replies (of 1 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi!

    Thanks for your post and sorry for the trouble!

    TablePress stores the table data as a two-dimensional array, encoded in the JSON format, in a “Custom Post Type” called tablepress_table, which are stored in the wp_posts database table.

    So, you would have to do the search/replace in that database table. Now, depending on how exactly the URL that you are replacing look like, you will just have to keep in mind that slashes can be treated differently in JSON: That is that internally, they can be stored with a backslash in front of them so that a URL like https://example.com/some-link/ might internally actually be stored as https:\/\/example.com\/some-link\/. So just as a try, also try the URLs with that change.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘Database names’ is closed to new replies.