How to delete posts that does not have a thumbnail?
How to delete posts that does not have a thumbnail?
mysql
Keeping database within limits, please help!
Keeping database within limits, please help!
Is it safe to convert tables from MyISAM to InnoDB?
Is it safe to convert tables from MyISAM to InnoDB?
Mysql / WordPress killing my server with 80k users [closed]
Mysql / WordPress killing my server with 80k users [closed]
WordPress site uses MyISAM, should I switch to InnoDB necessary?
You should have switched to InnoDB at some point in the past decade, but now is as good a time as you are going to find. 🙂 mysqldump will work the same way. MyISAM could not be backed up while the database is running either. Databases generally cannot be backed up by running using a … Read more
WordPress Ajax Custom Query – High CPU LOAD
WordPress Ajax Custom Query – High CPU LOAD
Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
Recent comments from my blogs only
There’s a different posts and comments table per site, so not really. That said, you can and should keep track of blog ids they’ve commented on in a user meta to speed things up in the first round, and cache the formatted result in a separate usermeta to speed things up in subsequent rounds. These … Read more
Importing users to Buddypress with custom fields
I ended up writing a bunch of MySQL statements. My process went: Add users into wp_users. Add first name into wp_usermeta. Add last name into wp_usermeta. Add nickname into wp_usermeta. Add last activity into wp_usermeta. (This is important for BuddyPress; otherwise, users won’t show up in the members-loop) Add name to BuddyPress. Add custom “phone” … Read more
Mass convert MySQL data entries into custom post type?
You can use the following method : Export your SQL data and make a CSV file out of it Parse that CSV file in a PHP script and put the data into an array Parse the array and for each row, insert the values into WP You will need the following functions to insert the … Read more