# 간단하게 아래처럼 처리 mysqldump -u [username] -p [databasename] --no-data > backup.sql all TRUE all-databases FALSE all-tablespaces FALSE no-tablespaces FALSE add-drop-database FALSE add-drop-table TRUE add-locks TRUE allow-keywords FALSE character-sets-dir (No default value) comments TRUE compatible (No default value) compact FALSE complete-insert FALSE compress FALSE create-options TRUE databases FAL..

Database 가 사용하는 character_set과 collation 확인 mysql console 로 접속한 다음 SELECT default_character_set_name, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA; 아래와 유사한 결과가 나오게 된다. +--------------+--------------------+----------------------------+------------------------+----------+ | CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH | +--------------+----..