Suapapa's Wiki

User Tools

Site Tools

Trace:
mysql

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
mysql [2009/08/04 06:28] – suapapamysql [2013/08/03 05:04] (current) – external edit 127.0.0.1
Line 9: Line 9:
 postCnt = cursor.execute('select id,post_content from wp_posts') #434L postCnt = cursor.execute('select id,post_content from wp_posts') #434L
 </code> </code>
 +
 +<img src="/wordpress/wp-content/uploads/2008/01/sfxn_in_t2_01.jpg" 
  
 ===== references ===== ===== references =====
Line 29: Line 31:
 mysql> EXIT mysql> EXIT
 </code> </code>
 +모든 테이블 지우기
 +<code mysql>
 +mysqldump --single-transaction -uID -pPASS --add-drop-table --no-data DB_NAME \
 +| grep ^DROP \
 +| mysql -uID -pPASS DB_NAME
 +</code>
 +
 ====== blog restore ====== ====== blog restore ======
 <code mysql> <code mysql>
Line 43: Line 52:
 Rows matched: 1  Changed: 1  Warnings: 0 Rows matched: 1  Changed: 1  Warnings: 0
  
-mysql> select option_name,option_value from wp_options where option_name='siteurl';                       +-------------+---------------------------------------++mysql> select option_name,option_value from wp_options where option_name='siteurl'; 
 ++-------------+---------------------------------------+
 | option_name | option_value                          | | option_name | option_value                          |
 +-------------+---------------------------------------+ +-------------+---------------------------------------+
mysql.1249367300.txt.gz · Last modified: 2013/08/03 05:04 (external edit)