Hi,
thanks for your question, and sorry for the trouble.
Is your data missing on the frontend or on the “Edit” screen as well?
TablePress stores the table data as a JSON-encoded two-dimensional array in the wp_posts database table, using a WordPress Custom Post Type “tablepress_table”.
Regards,
Tobias
In addition to @tobiasbg, remember the escaped characters!
I was running Find/Replace to convert all my href’s in TablePress
From: http, www, absolute
To: https, non-www, relative
So it looked something like:
Find: http:\/\/www.website.com\/
Replace: \/
Then I just amended under wp_options the siteurl and home
From: http://www.website.com
To: https://website.com
Hi,
yes, that’s imported when dealing with URLs or text that contains charactes like / or ".
Thanks!
Regards,
Tobias
Hello @tobiasbg,
I want to update img src url in all tables.
Could you please help me to find “tablepress_table” ?
Hi,
all TablePress tables are stored as JSON encoded two-dimensional arrays in the wp_posts database table, with a post_type value of tablepress_table.
Regards,
Tobias
Thanks. Here is one of links that I am wanting to change
img src=\”http:\/\/old-domain\/wp-content\/uploads\/2017\/05\/250px-Game_of_Thrones-196×300.jpg
old-domain to new-domain. Could you help me to deal with this?
Hi,
ok, now you just have to use a mySQL query for search/replace, which you can find via Google, e.g. https://stackoverflow.com/questions/11839060/find-and-replace-text-in-the-entire-table-using-a-mysql-query
Regards,
Tobias
I have tried
# update wp_posts set post_content = replace(post_content, ‘http:\/\/old\/’,’http:\/\/new\/’) but without luck.
MariaDB [videodb]> show tables;
+———————–+
| Tables_in_videodb |
+———————–+
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_mgmlp_folders |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_termmeta |
| wp_terms |
| wp_usermeta |
| wp_users |
+———————–+
13 rows in set (0.00 sec)
MariaDB [videodb]> update wp_posts set post_content = replace(post_content, ‘http:\/\/olddom\/’,’http:\/\/www.newdom.com\/’);
Query OK, 0 rows affected (0.45 sec)
Rows matched: 815 Changed: 0 Warnings: 0
-
This reply was modified 8 years, 9 months ago by
adminim.
-
This reply was modified 8 years, 9 months ago by adminim.
You could also use https://wordpress.org/plugins/better-search-replace/ .
Or HeidiSQL for example, to find/replace.
Hi,
that looks good to me, but unfortunately, I can’t really help with such mySQL problems at the moment 🙁 Sorry.
Make sure to properly wrap the field names with a
Another idea would be to export all tables to a JSON files (in a ZIP archive) and then run a search/replace like that in a text editor that can search/replace in multiple files at once (like Sublime Text). Then, just re-import the modified JSON files into TablePress.
Regards,
Tobias
Thanks for your reply @tobiasbg and @leotm. I will use mix of these advices.
Hi,
no problem, you are very welcome! 🙂
Best wishes,
Tobias
