User Tools

Site Tools


wordpress

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
wordpress [2009/08/06 12:18] suapapawordpress [2013/08/03 05:04] (current) – external edit 127.0.0.1
Line 8: Line 8:
 DELETE FROM wp_posts WHERE post_type = "revision"; DELETE FROM wp_posts WHERE post_type = "revision";
 </code> </code>
 +  *[[http://luv4.us/archives/1626|WP 자동저장/리비전 기능 조절하기]]
 <code python> <code python>
 mport MySQLdb mport MySQLdb
  
-db = MySQLdb.connect(db='suapapa_blog', user='blog_admin', passwd='enakflxhRl', host='localhost')+db = MySQLdb.connect(db='suapapa_blog', user='blog_admin', passwd='******', host='localhost')
 c = db.cursor() c = db.cursor()
 c.execute('DELETE FROM wp_posts WHERE post_type = "revision"') c.execute('DELETE FROM wp_posts WHERE post_type = "revision"')
Line 32: Line 33:
  
 db.commit() db.commit()
- 
- 
-</code> 
- 
-<code mysql> 
-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) 
 </code> </code>
  
Line 76: Line 62:
 $translations = unserialize(base64_decode($translations[0])); $translations = unserialize(base64_decode($translations[0]));
 </code> </code>
 +====== themes ======
 +  *[[http://getk2.com/|K2]]
 +====== references ======
 +  *[[http://codex.wordpress.org/Database_Description|WP Database Description]]
wordpress.1249561116.txt.gz · Last modified: 2013/08/03 05:04 (external edit)