= MySQL =

{{tag>database DBMS mysql}}


= Database 생성 =

<sxh bash>
# -p : Password를 입력받음
mysqladmin -u USERNAME -p create DBNAME
</sxh>


= Login =

<sxh bash>
# -p : Password를 입력받음
mysql -u ID -p
</sxh>


= Database 사용 =
<sxh sql>
use DATABASE_NAME
</sxh>


= Safe Mode 해제 =
<sxh sql>
SET SQL_SAFE_UPDATES = 0;
</sxh>

= Dump =
<sxh sql>
# Output
mysqldump -u USERNAME -p > create database DUMPNAME;

# Input
mysql -u USERNAME -p DBNAME < DUMPNAME
# OR
mysql -uroot -p < DUMPNAME
</sxh>