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 Page Rules Debt: The Quiet Failure Mode on Business Websites
  • Fixing Website Email Deliverability in 2026: What Business Websites Need to Get Right
  • Your CMS Upgrade Is Now a Stack Project: A 2026 PHP Roadmap for WordPress and Drupal Sites
  • WooCommerce scheduled-action backlog is still a paid operations problem for stores
  • Speculative Loading Is Now a CMS Operations Issue
RSS feed

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