Table of Contents

MySQL

Database 생성

# -p : Password를 입력받음
mysqladmin -u USERNAME -p create DBNAME

Login

# -p : Password를 입력받음
mysql -u ID -p

Database 사용

use DATABASE_NAME

Safe Mode 해제

SET SQL_SAFE_UPDATES = 0;

Dump

# Output
mysqldump -u USERNAME -p > create database DUMPNAME;

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