Edit WordPress posts with phpmyadmin

  • Resolved JCM

    (@chrisjeret)


    2 years, 6 months ago

    Hi I’m not sure if this is the right place to ask but could someone provide a solution for me?

    I’m trying to edit WordPress posts using phpmyadmin. The reason I’m doing this is I’m having issues with one of the plugins and it’s complicated to even explain.

    I have found the the db and posts and edited directly with phpmyadmin and I also tried sql command to update the posts. It’s basically just updating certain text in the posts. Running or updating in phpmyadmin was successful but it is not reflecting in the wordpress site.

    So I’m not sure if there is anything else that needs to be done?

    • This topic was modified 2 years, 6 months ago by JCM.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Dion

    (@diondesigns)

    If you’re using a cache plugin, you’ll need to purge the cache in order to see the changes. Purging may also be necessary if you’re using a proxy cache such as CloudFlare, or a server-level cache such as Redis, Memcached, or Varnish.

    Thread Starter JCM

    (@chrisjeret)

    hi im working on a localhost first to test it out before i do it on the production site and i do not have any cache plugin installed. i also tried using some search and replace plugin and that did not work either.

    on phpmyadmin i did this …

    UPDATE wp_posts SET post_content = REPLACE(post_content, ‘Alex’, ‘Robert’) WHERE post_type=’page’ AND post_status=’publish’

    Dion

    (@diondesigns)

    When you run that query, phpMyAdmin will tell you how many rows were affected by the query. Please make sure the number is nonzero.

    Also, are you sure the post you’re trying to edit is in fact a page?

    It would be beneficial if you knew beforehand some of the post IDs whose content you want to change. In that way you can view them in the WP editor (Gutenberg or Classic) to see what is in fact occurring.

    Thread Starter JCM

    (@chrisjeret)

    @diondesigns thanks for the input but I found a plugin that actually works. Tried few different plugins and finally found one that actually write the changes. It’s WP Migrate Lite plugin.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Edit WordPress posts with phpmyadmin’ is closed to new replies.