User Tools

Site Tools


wordpress

This is an old revision of the document!


disable revision & delete existing revision from db

wp-config.php에 다음 옵션 추가:

define(’WP_POST_REVISIONS’, false);

기존에 저장된 내용 삭제

DELETE FROM wp_posts WHERE post_type = "revision";
db = MySQLdb.connect(db='suapapa_blog', user='blog_admin', passwd='password', host='localhost')
c = db.cursor()
c.execute('select id from wp_posts')
l = c.fetchall()
postIDs = map(lambda x: x[0], l)
mysql> desc wp_postmeta;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| meta_id    | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| post_id    | bigint(20)   | NO   | MUL | 0       |                |
| meta_key   | varchar(255) | YES  | MUL | NULL    |                |
| meta_value | longtext     | YES  |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
wordpress.1249398482.txt.gz · Last modified: 2013/08/03 05:04 (external edit)