Skip to main content
GrN.dk

Main navigation

  • Articles
  • Contact
  • Your Digital Project Manager
  • About Greg Nowak
  • Services
  • Portfolio
  • Container
    • Excel Freelancer
    • Kubuntu - tips and tricks
    • Linux Apache MySQL and PHP
    • News
    • Image Gallery
User account menu
  • Log in

Breadcrumb

  1. Home

Mysqldump encoding

If you experience false characters in your mysqldump, you might want to try to set the encoding specifically. Example with latin1:

mysqldump -u [USER] -p --opt --skip-set-charset --default-character-set=latin1 [DATABASE_NAME] > [OUTPUT_FILE_NAME].sql

Check different encoding settings in mysql when using a specific database: show variables like 'char%';

More info and tips: https://www.toptal.com/php/a-utf-8-primer-for-php-and-mysql

Last modified
2021-08-06

Tags

  • Script
  • Linux

Review Greg on Google

Greg Nowak Google Reviews

 

  • Cloudflare Cache Response Rules Made Origin Header Debt a Paid Cleanup Job
  • Cloudflare Service Key Deprecation Turns Old DNS and SSL Scripts Into a 2026 Cleanup Project
  • Unsupported Theme Contracts Made WordPress 6.9.3 a Paid Troubleshooting Story
  • WordPress Playground Made Faster Reproduction Easier, but Plugin and Hosting Bugs Are Still Paid Troubleshooting
  • Drupal CMS 2.0 Makes Marketing-Site Rebuilds Faster, but Canvas, Recipes, and Governance Are Still Paid Work
RSS feed

GrN.dk web platforms, web optimization, data analysis, data handling and logistics.