Differences

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

--- mysql [2009/08/05 05:15] – suapapa
+++ mysql [2013/08/03 05:04] (current) – external edit 127.0.0.1
@@ Line 33: / Line 33: @@
 모든 테이블 지우기
 <code mysql>
-mysqldump --single-transaction -usuapapa -p8963hm --add-drop-table --no-data user_suapapa | grep ^DROP | mysql -usuapapa -p8963hm user_suapapa
+mysqldump --single-transaction -uID -pPASS --add-drop-table --no-data DB_NAME \
+| grep ^DROP \
+| mysql -uID -pPASS DB_NAME
 </code>
@@ Line 50: / Line 52: @@
 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                          |
 +-------------+---------------------------------------+