Monitor all the queriers executed by my website
The plugin Query Monitor will show all queries done on a single page. Also there is the query filter that you could use to log queries as they are made.
phpmyadmin
Can’t log into wordpress site – I have made a new user and still cant access
Can’t log into wordpress site – I have made a new user and still cant access
Delete user with only subscriber role
Here’s a plugin Please run with –dry-run first and also do a full database backup!
Export SQL query based on custom field?
Change your query to: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON wp_postmeta.post_ID = wp_posts.ID WHERE ( wp_postmeta.meta_key = ‘Color’ AND wp_postmeta.meta_value IS NOT NULL ); That way it only gets the data in wp_posts, but still filters based on your criteria.
Recovering a wordpress blog that got corrupted
Assuming you didn’t change the table prefix from wp-config.php, you can find your posts in the tables wp_posts and wp_postmeta.
Phpmyadmin – post editing
Mysql allows you to run queries that apply to all post, see example : UPDATE wp_posts SET POST_CONTENT = replace(POST_CONTENT, ‘<a href=”http://mysite.com/my_link”>mylink</a>’, ”); This code allows you to delete <a href=”http://mysite.com/my_link”>mylink</a>on all posts. But in your case I doubt all links are the same so you need a pattern. Perhaps it can be done with … Read more
SQL: Select wordpress posts with given text string and add a custom field to them?
Here you go (you’re really close): INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT ID AS post_id, ‘customer_reviews’ AS meta_key, ‘On_or_delete’ AS meta_value FROM wp_posts WHERE wp_posts.post_content LIKE ‘%Customer Reviews%’ AND wp_posts.post_type=”post”; ` Edit: You could also just change IS IN to IN. I rewrote the from part of the query since a subquery was unnecessary … Read more
Installing local to live WP into subdirectory
Since you want to test out your existing(local) site on the server; you have done the right thing as far as I can see on pastebin except for 1 thing On step 10 – you replaced all occurances of “localhost” with your servername. Instead you should have replaced it with servername/directoryName. If you still have … Read more
How to track who has deleted files
WordPress does not log anything natively. Closest it has to such functionality are just post revisions and ability to enable logging of PHP errors. There are plugins around to log events, but since you hadn’t one installed in advance it won’t help you retroactively. If you think it was from action by logged in user … Read more