I exported and then imported a wordpress mysql database from one server to another. On […]
Tag: mysql
Recent comments from my blogs only
I’d like to create a list of recent comments, specific to each user on my […]
MYSQL Statement INNER JOIN with multiple condition
I have a WP site where I’ve also got a few php pages outside of […]
Value inserted into MYSQL table differs from original value
I’m having the strangest problem with a value changing when I insert it to a […]
Export MySQL database install script from Webmatrix
Does anyone know the trick to force Webmatrix to create the MySQL database install scripts […]
Where are Custom Menus saved in the Database for WordPress 3.0?
I’ve been searching and searching my sql database in phpmyadmin but I can’t seem to […]
Mysqltuner suggestions and changes to my.cnf
Had this question on Serverfault for a few days with no luck. I’ve run mysqltuner.pl […]
MySql post archives. What’s the best way to handle massive archived posts that need to be kept?
If my wordpress site generates thousands(perhaps millions) of posts a day, what is the best […]
simple sql for mass changing passwords
Changing password for user 1 looks like this: UPDATE `mydb`.`wp_users` SET `user_pass` = MD5( ‘password’ […]
Compex MySQL Left Join using multiple entries from meta tables
I am trying to create a single query for getting information from the main table […]
No More Posts Available.
No more pages to load.