Try it like this:
1. Create backup.
2. Export the table to a sql file, open it in a text editor, select and delete unnecessary records (ex. by regexp), then import it back.
Related Posts:
- Store GravityForm data in phpmyadmin (mysql)
- How to properly insert data into custom table via plugin
- How does WordPress handle MySQL row lock errors?
- Can I explicitly specify ENGINE=InnoDB in WordPress?
- Bad Request (Invalid Hostname) on working server, database problem
- Changing BIGINT to INT
- greatest() function returns undefined property
- How to write one comment and publish on every post using database or plugin?
- How to determine what is generating large amount of database queries?
- Help With MySQL to WPDB Query Conversion
- How can I perform high-level database merging for WordPress within continues delivery?
- Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
- WordPress Backend HA (Automatic failover)
- import posts with dutch/special letters
- Automatic switch to backup database on fail
- Migrating to WordPress Recipe Plugin and Some SQL Issues
- Multiple instance of data in plugin custom database table on plugin activation
- after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
- How do i edit the plugin files in DataBase via phpMyAdmin?
- dbDelta not adding additional columns in plugin database update
- Always get creating a new table with foreign key
- How to do database for download stats?
- DB Query not working in Plugin
- External wpdb connections in different plugins on single page
- Way to send multiple values for column to MySQL?
- WordPress plugin: efficient way to store large data
- WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
- Integrating Custom Database with WordPress
- How to display results from a data table with an encrypted user id?
- add_action for publish_post doesn’t work
- What database state changes happen after a post is manually “updated” with no changes?
- Cant create table on plugin activation
- Performing CRUD operations on front end in wordpress
- Moving a few select DB tables to a new WP instance
- WordPress database problem wp_posts, primary key
- Login issue in WordPress
- HyperDB failover Delay
- Write mysql credentials in plugin
- How can I delete the options from DB when the plugin is deleted?
- How to run Two WordPress blogs with different themes and with single database and same content
- Create custom column in post table in wordpress
- Custom database or Custom Post Types?
- Add agenda items and notifications
- Export only pages and posts with mysql dump
- How to count number of records found in a database table?
- Taking WordPress table prefixes into account
- WordPress register_activation_hook table creation not working
- How to add Edit | Delete button on rows?
- The plugin generated x characters of unexpected output, $wpdb not defined
- clean wp_options table unused rows
- Can I run multiple queries with $wpdb->prepare?
- How Do I Merge Categories With phpMyAdmin
- How to remove duplicate Custom Fields?
- Get total number of comment of the posts written by an author
- How to get number of Affected rows from wordpress dbDelta() function
- Saving Custom Post types and fields to a custom table
- When to use action hooks and plugins
- WordPress database import: Row size too large
- How to create custom tables in WordPress using my own plugin?
- DROP TABLE with uninstall hook not working
- how to oauth1 Wp plug-in revoke/reset.?
- get current date + 90 days and checking every day
- WordPress + JavaScipt + AJAX + MySQL: insert query for form
- WordPress plugin creating database in localhost but not on real host
- Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?
- WordPress as a data-store?
- How to insert and call new data in wordpress website database through a plugin
- Separate database for a wordpress plugin
- Is there a rule for wordpress plugins developers to not do any database changes upon update?
- What is the WordPress approach to custom data?
- How retreive saved data from gravity forms in my template?
- speed up pagination for huge database
- Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
- How to relate 3 wordpress components with each other (Create database relationships)
- Creating a search form and displaying results
- phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
- How to access the WordPress DB from a plugin file
- Installing local to live WP into subdirectory
- Bulk Edit Media Library alt, caption, image names
- How to implement data residency in my WordPress site
- I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
- WordPress UPDATE queries on MySQL database stuck
- dbDelta not CREATING TABLE
- How wordpress handle urls present in db for external wp-content directory
- Delete user meta based on key value that is an array
- Many to many relationship for variable products
- Is it a good practice to use wordpress database to store pages contents which loading to page dynamically?
- Where do the section input fields values are stored in database
- How to save information related to post in database?
- RSS Feed has no Items (Possible Plugins Conflict)
- A plugin is giving me “You do not have sufficient permissions to access this page.” error
- Creating fields in the database
- Allow users to enter and edit data in one-to-many configuration
- Updating WordPress [closed]
- how to search through plugin in wordpress cimy-user-extra-fields?
- Get all the related data from WordPress DB
- 504/502 errors plauging our site
- Does anyone recognize these table names?
- Edit a page/post DB data?