King Php

Sometimes there are thousands wordpresss comments there, it is too difficult to delete them. Any method to delete them one time without login phpmyadmin?

The answer is yes, the follow code can help you.

include(‘wp-config.php’);
mysql_query(“truncate table wp_comments;”);

Copy the code to file delete_wp_comment.php, and put the file under your blog. Run it, all comments will be deleted!

If you only want to delete spam or trash comments, please visit http://kingphp.com/160.html , and just change some code. Very simple!

Q:I want to mass delete my trash with 2000+ Posts in it. Is there a mysql command to do so?

A: Please backup before running the query, i’ll not take responsibility if something goes wrong as a result..

DELETE p
FROM wp_posts p
LEFT OUTER JOIN wp_postmeta pm ON (p.ID = pm.post_id)
WHERE post_status = ‘trash’

Join is optional, removes entries from the meta table (if they exist).

Check your data base table prefix also, if it is not wp_, you have to change it to your table prefix.

Tested under MySQL 5.1 in Phpmyadmin.

After install zen cart v1.3.9h, the front page show:

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM’ at line 1

CREATE TABLE seo_cache (`cache_id` varchar(32) NOT NULL default ”, `cache_language_id` tinyint(1) NOT NULL default ’0′, `cache_name` varchar(255) NOT NULL default ”, `cache_data` mediumtext NOT NULL, `cache_global` tinyint(1) NOT NULL default ’1′, `cache_gzip` tinyint(1) NOT NULL default ’1′, `cache_method` varchar(20) NOT NULL default ‘RETURN’, `cache_date` datetime NOT NULL default ’0000-00-00 00:00:00′, `cache_expires` datetime NOT NULL default ’0000-00-00 00:00:00′, PRIMARY KEY (`cache_id`,`cache_language_id`), KEY `cache_id` (`cache_id`), KEY `cache_language_id` (`cache_language_id`), KEY `cache_global` (`cache_global`) ) TYPE=MyISAM

Very simples, just change “TYPE=MyISAM” to “ENGINE=MyISAM”, and login in phpmyadmin, run the mysql sentense, done!

 

<?php 
$DB_Server = “localhost”;   
$DB_Username = “put your user name here”;   
$DB_Password = “put your password here”;   
$DB_DBName = “put your database name here”;   
$DB_TBLName = “put your table name here”;   
  
$savename = date(“YmjHis”);  // excel file name
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die(“Couldn’t connect.”);   
mysql_query(“Set Names ‘utf-8′”); Continue reading “Using PHP to Export Mysql Data to Excel”

Sometimes we want to change hostgator mysql database user password, or we have to change when we forgot the password. How to do?

Very simple infact, first delete the user name of the mysql and remake it, but make sure you use exactly the same name when remaking.

then bind the old database name to the new database user name.

next modify the user password in your software config file, for example, if you use wordpress, you have to modify wp-config.php; if you use vbulletin forum, just modify config.php