Testimonial Pro database - Forum | JoomShaper
Staff replied SP Page Builder

Testimonial Pro database

Asked by LEONIDHA DHEFTO 4 years ago Last activity 4 years ago

Hello, I use DB repacer (https://regularlabs.com/dbreplacer) and I need to locate the testimonial pro so I can mass replace some entries.
Can you please advise me accordingly?

3 replies

Oldest first Newest first Most helpful
Paul Frankowski Senior Staff
4 years ago · edited

Hi,

it's not so simple as you may think, but you can try. Database backup first (!)

Tip#1: In table "prefix_sppagebuilder" there are records of all pages, and page data (settings/content of addons) is stored in one long text field.

Tip #2:
In DB Replacer tool choose "sppagebuilder" and "text" then search inside it words to replace etc. More in RegularLabs guide.

foto_7730_2022.jpg

LEONIDHA DHEFTO Asked this
4 years ago

Hello, I tried to work on the proposed solutions above with no luck.

  1. The table "prefix_sppagebuilder" doesn't exist in my list of tables...
  2. sppagebuilder, text returns nothing from testimonial addon entries.

Is there any way or tool to attack this from another side? Where the entries are stored anyway in the database?

Paul Frankowski Senior Staff
4 years ago · edited

ad 1) Have you seen my screenshot?? In Db Replacer "sppagebuilder" table is used.
But in PHPMyAdmin all tables have unique prefix then there is "_sppagebuilder"
try to search two words from phrase, easier to find.

OR

Use PhpMyAdmin from cPanel - and search option, to find those words.

    • sorry, I cannot help more
Log in to reply.