DEV Community

Katz Ueno
Katz Ueno

Posted on

1 1

How To Check mysqldump character-set

Learning from mistake.

mysqldump doesn't respect database's collation, but mysql client.

Check your mysqldump default character set by typing

mysqldump --help | grep default-character-set
Enter fullscreen mode Exit fullscreen mode

You always want to add --default-character-set option

Example

mysqldump -h {$host} -u {$db_username} --password="{$db_password}" --default-character-set=utf8mb4 --single-transaction {$db_name} > {$SQL_file_name}
Enter fullscreen mode Exit fullscreen mode

--single-transition option is my preferences for the database which mainly uses InnoDB

Top comments (0)

AWS Security LIVE!

Join us for AWS Security LIVE!

Discover the future of cloud security. Tune in live for trends, tips, and solutions from AWS and AWS Partners.

Learn More

👋 Kindness is contagious

Engage with a wealth of insights in this thoughtful article, valued within the supportive DEV Community. Coders of every background are welcome to join in and add to our collective wisdom.

A sincere "thank you" often brightens someone’s day. Share your gratitude in the comments below!

On DEV, the act of sharing knowledge eases our journey and fortifies our community ties. Found value in this? A quick thank you to the author can make a significant impact.

Okay