Mastodawn

BLACKVOID ⚫️Aug 4, 2025

#Ghost6 has arrived! Looks like I will be updating as soon as 6.1 comes out! ;)

Nothing major in terms of breaking changes that was not expected and the #MySQL8 is still the supported version.

https://github.com/TryGhost/Ghost/releases/tag/v6.0.0

#selfhost #selfhosting #homelab #cms

Show thread

Tokyo Outsider (337ppm)Aug 3, 2025

2/2 ...

The top of the exported file has these lines:

CREATE DATABASE IF NOT EXISTS `databaseName` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `databaseName`;

If I change "databaseName" to a different name, is that enough for it to restore everything from the export file to a new database of a different name?

#backups #databases #InnoDB #MySQL #MySQL8 #MySQLworkbench

Tokyo Outsider (337ppm)Aug 3, 2025

#MySQL8 backup/restore question

If I've exported my database to a single SQL file, and checked "Include Create Schema", how can I do a test restore without it dropping and/or recreating the existing database from the backup (which I'm trying to test, so isn't yet known to be reliable)?

1/2 ...

Qiita - 人気の記事 Jan 22, 2025

【MySQL】知っておくと便利なinformation_schemaのクエリ集
https://qiita.com/lvn-okino/items/d2797f17398410973ae8?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #Database #mysql8 #information_schema

【MySQL】知っておくと便利なinformation_schemaのクエリ集 - Qiita

はじめにINFORMATION_SCHEMAはデータベースのメタデータが格納されているデータベースです。以下、公式ドキュメントの解説になります。INFORMATION_SCHEMA では、データ…

Qiita

David Goodwin Nov 8, 2024

This week has been mostly messing around with doing a point in time restore for mysql and testing / bug fixing upgrading to mysql 8.

So far the only annoyance is json_set() changing numeric values into floats when they were ints before.

#Mysql8 #azure

Rad Web Hosting Oct 23, 2024

How to Install MySQL 8 on VPS Server
#mysql #mysql8 #vps #Cloud #Guides #VPS
https://blog.radwebhosting.com/how-to-install-mysql-8-on-vps-server

How To Install MySQL 8 On VPS Server - VPS Hosting Blog | Dedicated Servers | Reseller Hosting

This guide demonstrates how to install MySQL 8 on VPS server. First login to the VPS as root user and run the appropriate commands based on Linux distro:

RadWeb, LLC

Habr Jun 6, 2024

Инструкция: как перенести сайт WordPress с MySQL 5.7 на MySQL 8

Недавно WordPress при проверке здоровья сайта начал рекомендовать использование версии MySQL 8. В этой статье расскажем, как перенести сайт на WordPress на MySQL 8 на примере нашего хостинга. Спойлер: это намного легче, чем может показаться.

https://habr.com/ru/companies/spaceweb/articles/819925/

#миграция_сайта #перенос_на_MySQL8 #MySQL8 #mysql #wordpress