Is there a way to edit the WP content database in an admin panel or external page?

I wouldn’t recommend doing this Tchai. The whole point of a CMS is to make editing your site simple.

If you’re determined to do this, I would go to tools > export and export the page or post data. This will give you an XML feed with all of the posts data on it. You can then re-import it in the same format. However, be very careful doing this. If you edit the wrong thing, delete the wrong thing, it could invalidate the structure. When you come to re-upload it it could be corrupted and either not upload, or worse, upload corrupting your site’s database.

If you do decide to do this, make sure you have backups in place!

Related Posts:

  1. What is this JavaScript “require”?
  2. Oracle SQL query for Date format
  3. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  4. Can I have multiple primary keys in a single table?
  5. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  6. get_results using wpdb
  7. wpdb->insert multiple record at once
  8. How to migrate a HTTPS WordPress installation to localhost?
  9. Database connection close
  10. How to monitor server for error establishing a database connection
  11. How to create bulk page and content? [closed]
  12. Importing posts from old website to new conflicting post ID’s?
  13. Default WordPress settings API data sanitization
  14. Fatal error: Call to undefined function dbDelta()
  15. Connect to remote database using Localhost install
  16. remove missing image attachments
  17. Transient RSS feeds in wp_options not removed automatically?
  18. Best way to move live site local
  19. The revisions table in my database is at 70% capacity and growing. What should I do?
  20. WordPress for a very large website
  21. How to ensure data consistency in WordPress
  22. Database location in WordPress
  23. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  24. WP_list_table bulk_action get edit and delete
  25. How to display data from custom table in wordpress database?
  26. How to intercept update_option() before it saves data?
  27. Change SQL get_results to search for posts with custom term in custom taxonomy
  28. wpdb query on custom table not working [closed]
  29. How to diagnose and keep in check encoding issues?
  30. Add search Value to wp_list_table pagination
  31. stdObject stored in database. How does one convert it to usable format?
  32. I have a table I created, how do I make a form for a user to filter the data?
  33. What ALL can cause “Another update is currently in progress.”? [closed]
  34. How to fix unchanged URLs in Database after running serialized search and replace script?
  35. Trigger Plugin database update after git pull
  36. wp_redirection_404 table has grown to 7GB
  37. Does WordPress ever need multiple databases?
  38. Why are no posts showing despite my apparently correct DB restoration?
  39. Cannot update custom database table row
  40. Change WordPress prefix for only one table?
  41. Multiple wp_options tables to share content across installs
  42. Select two sums with single get_var statement
  43. How to get the SQL of the changes made to the database from an update or upgrade?
  44. Merging two databases without borking it
  45. Is there a smart way to obtain a list of only some selected user meta data?
  46. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  47. Permit Login if table row exists
  48. Make an Items attribute searchable (taxonomy using existing attribute)
  49. How Yoast SEO plugin works with variable %%name%%?
  50. What would Repair and Optimize WordPress Database do?
  51. Store partial database to an archive database time to time
  52. Saving zero as meta value
  53. Migration: Copying database content to a different server
  54. Query multiple tables at once?
  55. Transferring/Uploading Data from DB to WordPress
  56. How to convert srcset links from https to http?
  57. Delete all posts that do NOT have a specific tag
  58. Changing order of db results when encoding to JSON
  59. How to transfer from localHost to live but use the already existing database on the server?
  60. Backing up WordPress database and files
  61. How not to display ALL items of a database
  62. Connect a membership plugin to an external database
  63. How to get the records from start with A to G in php and mysql
  64. Storing user’s data on external database on other server
  65. Link multiple user databases together?
  66. is it right choose to connect database in template page directly in WordPress site?
  67. How to insert a value to decimal type field using wpdb->prepare?
  68. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  69. Set a cron job to delete a specific database table table every midnight
  70. Two separate wordpress installations at one domain
  71. /wp-admin not accessible after migrating to local host (no plugin issue)
  72. set_transient fails if the value has more than 60.000 characters
  73. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  74. error establishing database connection (WAMP + filezilla)
  75. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  76. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  77. How do I update a WordPress wp_postmeta meta_value that contains many options
  78. How can I get $wpdb to show MySQL warnings?
  79. About wp database hooks (error establishing connection)
  80. Database for JQuery Autocomplete field
  81. Auto populate form fields based on serial input or pull listings from other websites?
  82. How to extract some part of WordPress full source code
  83. Create Tables in WordPress
  84. Error establishing a database connection for some files
  85. Hash user emails in database?
  86. WordPress Failed to Login (DB Error)
  87. Weird characters in title if it contain “ ”
  88. Share WordPress Database
  89. DB access blocked when initializing WP externally
  90. Saving data to database and exporting to excel
  91. Site does not work right, pages not showing up, even for root admin
  92. ERROR: “Table Prefix” must not be empty
  93. How do you build a database-centric site in WP?
  94. One information repeated on multiple locations on one site [closed]
  95. WordPress: Interact with Database Query Data and Login
  96. Attach posts based on category and position
  97. Showing Error(TAble already exist)
  98. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  99. SQL query to rewrite all media URLs to end with .webp
  100. Many images in wp-content/uploads folder that are not in Media Library
error code: 523