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

mysql

By Greg Nowak, 6 August, 2021

Mysqldump Encoding: How to Avoid Broken Characters in Exports

Broken characters in a mysqldump usually mean the connection charset is wrong, not just the file output. This guide shows how to verify schema and column charsets, export safely, and avoid bad handoffs during migrations or client work.

Tags

  • mysql
  • Linux
  • database
  • migration
By Greg Nowak, 9 February, 2021

MySQL Tips and Tricks: Fix Zero Date Import Errors Safely

Legacy MySQL imports often fail because newer defaults reject zero dates. This guide shows how to inspect `sql_mode`, find affected columns, use a safer session-level workaround, and decide when to fix the schema instead.

Tags

  • mysql
  • database
  • migration
  • DevOps
By Greg Nowak, 5 April, 2019

Install a Specific Version of MySQL Server on Ubuntu

The old mysql-server-5.6 shortcut is outdated. This guide shows the current way to choose a MySQL release series on Ubuntu or Debian, install it through Oracle's APT repository, and handle exact-version or legacy requirements without creating avoidable ops risk.

Tags

  • mysql
  • Ubuntu
  • DevOps
  • Server Administration
mysql

Review Greg on Google

Greg Nowak Google Reviews

 

  • June 2026 WordPress Plugin Exploits Put Inventory to the Test
  • Sending Mail with Drupal: Reliable Email Setup for Business Sites
  • Cloudflare SSL for a VPS: A Practical Setup Without the Gotchas
  • Enable TLS on a Linux Mail Server Without Breaking Delivery
  • Long-running AI automations need queues before they meet real ops
RSS feed

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