garbled characters

[funtask]

hello, 3q for following this question garbled characters occur during backup,is it character can be set?

[deitch]

Can you give an example to replicate it?

[funtask]

thanks for your reply. my db contains chinese character i used docker-compose.yml to backup my db and i got disorder code.

---

version: '3' services: mysql: image: mysql:5.7 container_name: mysql ports:

• "3306:3306" command: --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --default-authentication-plugin=mysql_native_password volumes:
• ./db/conf:/etc/mysql/conf.d
• ./db/data:/var/lib/mysql
• ./db/init-sql:/docker-entrypoint-initdb.d
• ./db/log:/var/log/mysql
• /etc/localtime:/etc/localtime environment: MYSQL_ROOT_PASSWORD: xxxxxx restart: always backup: image: databack/mysql-backup container_name: db-backup volumes:
  • ./db/backup:/backup
  • /etc/localtime:/etc/localtime environment:
  • DB_NAMES=app
  • DB_DUMP_TARGET=/backup
  • DB_USER=root
  • DB_PASS=xxxxxx
  • DB_SERVER=server
  • DB_PORT=3306
  • DB_DUMP_FREQ=60

    - DB_DUMP_BEGIN=2200

  • DB_DUMP_DEBUG=true user: root depends_on:

• mysql restart: always

[deitch]

It would be really helpful if you could post a sample database with the characters that causes failure. I can then work with it until it works correctly.

Maybe create a small database with it, shut it down, zip it up, and post it here or in a gist, depending on size?