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?
- PHP message: WordPress database error Deadlock found when trying to get lock
- How can I store user preferences in WordPress and retreive them later?
- Enable plugins that are “not supported”
- submit form data to wordpress existing database table using my plugin
- Delete user meta based on key value that is an array
- Many to many relationship for variable products
- errno: 150 “Foreign key constraint is incorrectly formed” [closed]
- Is it a good practice to use wordpress database to store pages contents which loading to page dynamically?
- get/show Last ID
- Database error when user logs in
- one admin for 2 wordpress websites
- using wordpress login details for other website / application / forum?
- Where do the section input fields values are stored in database
- database – multiple wordpress installations using same database – can they share plugin settings?
- how to create database to use it in wordpress website?
- My plugin can’t see my files
- Resetting AUTO_INCREMENT primary key
- how can i get records from wp_postmeta table using particular meta_key in database?
- How to create a custom page for unrelated database?
- Missing latest posts and options after DB migration via phpMyAdmin
- User content database [closed]
- Need help for creating custom table on wordpress
- Re-writing MySQl query for execute faster
- Show a table from data submitted by a form from a user
- Check if a database is well installed
- Create Database Tables on Plugin Activation hook
- Include plugin form in the home page
- Help with sorting and storing data on WordPress
- How to save information related to post in database?
- Create user assessment and use results in sql query
- Is saving multiple options or saving multiple items in one option better?
- WordPress custom posttype meta values doesnot save
- Slow WordPress admin panel with a total query time of 1664ms
- RSS Feed has no Items (Possible Plugins Conflict)
- A plugin is giving me “You do not have sufficient permissions to access this page.” error
- Linking Plugin Files to WP
- Collaborate on wordpress local website, share files via dropbox?
- Pull Data from DB for Admin Page Display as Relates to Admin Page Class by BA Internet
- Posts are deleted everyday at night
- MySql Query for WordPress
- Display Plugin information on specific url
- How to find an option in the database?
- wpdb get_var is not returning any result (verified mysql query returns only one value)
- Insert data in custom table during new post creation
- Is there a plugin that will override the “Error establishing a database connection” message? [closed]
- Get the url of attachments from the post?
- Managing database tables in WordPress multisite
- Create New Admin Menu Section – Like how custom post type works, in a way
- Creating fields in the database
- Allow users to enter and edit data in one-to-many configuration
- How to submit the custom form data in database in WordPress without plugin?
- Using wp config to connect to a DB from a plugin
- Updating WordPress [closed]
- Is it safe to increase/alter the size of the wp_post.guid column from VARCHAR(255) to VARCHAR(2048)?
- Duplicator live to wamp https to http
- Website keeps going down, is it a plugin, database, memory problem, or something else?
- Is it possible to recover Deleted users?
- how to search through plugin in wordpress cimy-user-extra-fields?
- User register hook can’t access form request
- Get all the related data from WordPress DB
- How to display blog posts only authored by the administrator