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

 

  • WordPress Google PageSpeed: Practical Fixes for Core Web Vitals
  • Ubuntu Server Dashboards and Monitoring Tools: When to Use Cockpit, Monit, ISPConfig, or Landscape
  • Apache 2.4.67 Put Legacy Reverse Proxies Back on the Risk List
  • Web Search and Citation Controls Turn AI Research Assistants Into a Source-Governance Project
  • Drupal 9: Practical Upgrade Guidance for Legacy Sites
RSS feed

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