Sergio kallookoo

Possible solution

Export the database

sudo mariadb-dump --default-character-set=latin1 database > database.sql

Remplace mariadb-dump by mysqldump for MySQL

Edit the database.sql and change the /*!40101 SET NAMES latin1 */; by /*!40101 SET NAMES utf8mb4 */;

After trying the proposed [solution][1] and seeing that it still doesn't work.

The original code says to define MANPATH as explained in the man page, but when the man command reads the file, it append to MANPATH. So any command that exists in system man path (/usr/share/man, /usr/local/share/man) and was installed with brew, will show the man page inside of the system man path.

I started testing until I found a solution.

sudo mkdir -p /usr/local/etc/man.d
sudo tee /usr/local/etc/man.d/homebrew.man.conf <<'EOF' >/dev/null
manpath "/opt/homebrew/share/man:$manpath"

	SELECT
	p.ID AS product_id,
	sku.meta_value AS sku
	FROM wp_posts AS p
	LEFT JOIN wp_postmeta AS sku
	ON sku.post_id = p.ID
	AND sku.meta_key = '_sku'
	LEFT JOIN wp_postmeta AS thumb
	ON thumb.post_id = p.ID
	AND thumb.meta_key = '_thumbnail_id'

	#!/usr/bin/env python3

	import re
	import argparse
	import shutil
	from pathlib import Path

	def split_escaped(s, delimiter):
	"""Split a string by a delimiter, ignoring escaped delimiters."""
	parts = []

	#!/usr/bin/env bash
	#
	# HOW TO:
	# curl -fSs https://gist.githubusercontent.com/kallookoo/09df0bb28aa3c7927fb40c474923a411/raw/systemd-hgfs.sh \| sudo bash
	#
	# INFO:
	# https://knowledge.broadcom.com/external/article/316336/enabling-hgfs-shared-folders-on-fusion-o.html

	if [[ "$(id -u)" -ne "0" ]]; then
	echo "This script must be run as root, please run this script again with the root user or sudo."

	{
	"WordPress: Prevent Direct Access to files": {
	"prefix": "wp-secure-file",
	"body": [
	"defined( 'ABSPATH' ) \|\| exit;",
	"$0"
	]
	},
	"WordPress: Plugin Headers": {
	"prefix": "wp-plugin-headers",

	<!-- Tomorrow Night theme with Terminal options ( Window, Tabs, etc... ) -->
	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
	<plist version="1.0">
	<dict>
	<key>ANSIBlackColor</key>
	<data>
	YnBsaXN0MDDUAQIDBAUGBwpYJHZlcnNpb25ZJGFyY2hpdmVyVCR0b3BYJG9iamVjdHMS
	AAGGoF8QD05TS2V5ZWRBcmNoaXZlctEICVRyb290gAGjCwwTVSRudWxs0w0ODxARElVO
	U1JHQlxOU0NvbG9yU3BhY2VWJGNsYXNzRjAgMCAwABACgALSFBUWF1okY2xhc3NuYW1l

	DELETE FROM `wp_actionscheduler_actions` WHERE `status` IN ( 'canceled', 'failed', 'complete' );

	TRUNCATE `wp_actionscheduler_logs`;

	<?xml version="1.0"?>
	<ruleset name="WooCommerce-WordPress">
	<description>Exclude pattern directory and include subdirectory</description>
	<!-- Replace "parent-directory" with the directory to exclude. -->
	<!-- Replace "include-directory" with the subdirectory to include. -->
	<exclude-pattern>/parent-directory/((?!include-directory))</exclude-pattern>
	</ruleset>

	function xman() {
	open "x-man-page:/$(printf '/%s' "$@")"
	}