Programmer's Note

mysqldump -u [username] -p[password] databasename table1 table2 > filename.sqlmysqldump -u [username] -p[password] databasename < filename.sql

sudo vi /etc/mysql/my.cnf [client] default-character-set = utf8 [mysqld] init_connect = SET collation_connection = utf8_general_ci init_connect = SET NAMES utf8 character-set-server = utf8 collation-server = utf8_general_ci [mysqldump] default-character-set = utf8 [mysql] default-character-set = utf8

table1 + table2 = table3 INSERT INTO table3 SELECT * FROM tabel1 UNION SELECT * FROM tabel2

문제MySQL 로 CSV를 import하려고 할 때 아래와 같은 메시지가 나오면서 안될때The content of the file '파일이름' cannot be read with the used codepage 949. 해결1.메모장으로 해당 파일을 연다.2.다른이름으로 저장하기 > 인코딩: utf8 > 저장

http://www.mysqlfront.de

다운로드https://dev.mysql.com/downloads/file/?id=474262 압축해제C:\Portable\MySQL\mysql-5.6.39-win32 환경설정C:\Portable\MySQL\mysql-5.6.39-win32\mysql-5.6.39-win32.ini [client] character-set=utf8 [mysql] default-character-set=utf8 [mysqld] #skip-grant # set basedir to your installation path basedir=C:/Portable/MySQL/mysql-5.6.39-win32 # set datadir to the location of your data directory datadir=C:/Portable..