Yes you can. To delete posts with inherit post meta, use following code: DELETE p,pm FROM wp_posts p JOIN wp_postmeta pm ON pm.post_id = p.id WHERE p.post_name IN (‘post-1’, ‘post-2’, ‘post-3’) Pass slugs array to WHERE clause. If you want to delete only posts w/out postmeta (for some reason), use this code: DELETE FROM wp_posts … Read more
You may use a simple query and loop with wp_update_post function to update the post providing ID, post type by checking the words with preg_match The following example shows a simple update to the post status for all posts in a loop for which post title does not contain Hello or content does not contain … Read more
You can “workaround” the issue with a redirect in .htaccess, although it’s not clear why this double-domain-URL would be accessible in the first place. So, we can redirect URLs of the form example.com/example.com/?cat=6 to example.com/?cat=6, which you then say is correctly redirected to example.com/category by WordPress. For example, at the top of your .htaccess file: … Read more
Problem is within function query_abstract_post_table where you have ‘$ids’ wrapped in single quotes: Problem: $sql = “SELECT * FROM $table_name WHERE ID NOT IN (‘$ids’)”; In the above example, only the first ID returned in the concatenated string (from the array) will be recognized by the NOT IN clause. Solution: $sql = “SELECT * FROM … Read more
If you have already created the database that you wish to import into and you have selected that database in PHPMyAdmin, but the import file is trying to create a new database, then you will see this error message. All you need to do is open up the SQL file in a text editor and … Read more
The sticky posts info is stored in the sticky_posts option in the options table. It’s stored as serialized array e.g. a:2:{i:0;i:1272;i:1;i:1995;} You can modify it via the Options API but there’s a way to bulk edit posts in the backend: 1. Select the Sticky view: 2. Select all sticky posts and apply the bulk Edit … Read more
One disadvantage of using that SQL query is that the slug will only be updated when you really go edit the post. Plus, it might cause odd behavior when any plugin tries to do something with an empty slug. A good alternative would be to use WP-CLI instead. First, you’ll need a list of all … Read more
Ok, based on that, I’m almost positive that you need to re-enable permalinks for your site. You are probably missing your .htaccess file or it is missing WordPress’s rewrite rules. Go to your admin and find Settings > Permalinks. Select an option, and click “Save Changes” twice (there is a quirk that this avoids). This … Read more
Just log back into your admin, go to Plugins, and reactivate each of the plugins you use.
Create a new wordpress installation. Then import the data using the importer. Its not that you are copying the old database with this method, it is more accurately importing the data from the old database, to the new one.