MySQL 썸네일형 리스트형 [Docker] Run Mysql Server container and setup # Make Data folders for mysql volumnmkdir /data # Run mysql container docker run \-p 3306:3306 \--name mysql_server \-v /data:/var/lib/mysql \-e MYSQL_ROOT_PASSWORD={{SERVER ROOT}} \-e MYSQL_USER={{USER_ID}} \-e MYSQL_PASSWORD={{USER_PASSWORD}}} \-e TZ='{{TIMEZONE}}' \-d mysql:8.0.13 # Got error with message "MySQL 8.0 - Client does not support authentication protocol requested by server; consid.. 더보기 Max length of mysql TEXT field type TINYBLOB, TINYTEXT L + 1 bytes, where L < 2^8 (255 Bytes)BLOB, TEXT L + 2 bytes, where L < 2^16 (64 Kibibytes)MEDIUMBLOB, MEDIUMTEXT L + 3 bytes, where L < 2^24 (16 Mebibytes)LONGBLOB, LONGTEXT L + 4 bytes, where L < 2^32 (4 Gibibytes) 더보기 DB dump with single transaction mysqldump [DB Info] [dump option] [dump target] > /path/to/dump/file.sql If you want to dump with single transaction..just add one option in [dump option] That is "--single-transaction" options.It make the dump process to slow, but it did not lock the table.So you can insert, update...etc..during the db dump process. 더보기 이전 1 2 3 4 ··· 6 다음