Can’t update WordFence Options, clear data manually

I found a post on Stack Overflow advising that converting a column from blob to text should result in no data loss. I didn’t really care about data loss since I wanted to remove the plugin data anyway, so I gave it a shot.

On the Structure tab in phpMyAdmin, I edited the val column and changed it to text. Then I found the option for deleteTablesOnDeact and changed the value from 0 to 1.

After doing this, I was able to deactivate the plugin and the tables were all removed.

Related Posts:

  1. Delete all post meta except featured image
  2. Set Display Name to first and last name (phpmyadmin SQL Query)
  3. Emojis getting converted to “?”
  4. Delete all post meta except featured image Using SQL
  5. WordPress database import: Row size too large
  6. Changing root password in PHPMyAdmin for WordPress Database when going live
  7. Files on Localhost, Database on Server
  8. Installing local to live WP into subdirectory
  9. DB prefix not updating
  10. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  11. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  12. Missing latest posts and options after DB migration via phpMyAdmin
  13. Check if a database is well installed
  14. Deleting WordPress posts and media files based on author via MYSQL database
  15. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  16. MySQL SELECT increment counter
  17. How to create a foreign key in phpmyadmin
  18. Using wpdb to connect to a separate database
  19. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  20. WordPress Database lost auto increment
  21. wpdb->insert multiple record at once
  22. Restoring WordPress posts from database only
  23. Slow wp_term_relationships query
  24. How to use “TRUNCATE TABLE” MySQL statement?
  25. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  26. What are conventions about the schema of the $table_prefix
  27. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  28. Is deleting orphaned wp_options entries safe?
  29. How to solve slow WordPress site caused by attachment_metadata
  30. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  31. WooCommerce – Query for ordered products
  32. Large database causes slow load
  33. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  34. Database slowdown after update to 3.4.1
  35. Query WordPress database by registered date and role
  36. Tons of Twitter rows in my database
  37. How to insert data into MySQL database from the form created in WordPress site
  38. How to replace values in WordPress DB using phpMyAdmin
  39. Select Multiple meta_value from WP DB; Single Query
  40. Which is more efficient? Using usermeta, or creating a new MySQL table?
  41. Is it possible to split database tables using HyperDB?
  42. What happens if I overwrite the current wp_options table with a backup from a week ago?
  43. SQL Error wp_commentmeta – incorrect table definition
  44. WordPress database error – Error in SQL syntax – I can’t identify any error?
  45. CRUD operations using WordPress database API
  46. Handling large N data in WordPress
  47. How to Mirror WordPress database from Remote server to Local server
  48. Is MariaDB’s Aria storage engine suitable for WordPress?
  49. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  50. A MySQL DB within a MySQL DB
  51. How do I query wp_options for expired transient pairs with MySQL commands?
  52. Will changing the folder name two directories above a fresh wordpress installation break the site?
  53. Is there a way to recover the table wp_term_relationships?
  54. Trouble Migrating all data blog from WordPress.com to WordPress.org
  55. WordPress running SQL query to update database from form
  56. How to fix database error duplicate entry
  57. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  58. Remove empty rows from the database
  59. Custom WordPress Table wpdb
  60. Why this query is not showing any result on wordpresss home page?
  61. Best practice to limit results in get_row()?
  62. How to migrate a database from a server to another
  63. Trouble running $wpdb->query() with last_insert_id
  64. how to encyrpt DB_PASSWORD in wp-config
  65. Moving WordPress site to new domain – database import [duplicate]
  66. Changing order of db results when encoding to JSON
  67. Backing up WordPress database and files
  68. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  69. Error establishing a database connection (Set-up locally)
  70. Link multiple user databases together?
  71. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  72. Is there any defects for using same database prefix in WordPress for multiple sites?
  73. How can I find user role in Mysql?
  74. How to import products in host instead of database on wordpress?
  75. syntax error for changing user role from database
  76. I would like some help wth an SQL query to link posts with categories
  77. Where is the HTML-handler part in the wpdb class?
  78. Featured image from custom to WordPress database
  79. WordPress Database Query works in phpMyAdmin but not in the code
  80. Delete all users meta that named: user_avatar
  81. Merging development site with live site
  82. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  83. How to retrieve user data based on role using SQL?
  84. spambot registering without providing email or password, bypassing registration process
  85. Possible to restore wordpress database from mysql56 and sqlite files?
  86. live site do not update after importing sql database
  87. Widgets with *internal* links do not display after database migration
  88. How do i get value from wp_postmeta?
  89. Options table – where does my values go?
  90. “MySQL server has gone away” since update to 3.8
  91. featured image not showing up with mysql_connect
  92. Print output of Table Creation
  93. Importing Concrete5 content to WordPress
  94. why you don’t Implement PDO for access every thing to database
  95. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  96. Uploading to WordPress Database
  97. Have WordPress Use a Different Database for users
  98. How to generate PDF dynamically based on values from the database in WordPress
  99. How to manually delete post from database without causing conflicts?
  100. Count views without get_post_meta