bitScry

  • Home
  • About
  • Blog
  • Contact

MySQL

About this site

This is a blog to help me remember some of the coding challenges I’ve faced and hopefully help others out if they’re suffering the same problems.

Recent Posts
  • Cloning a Private Repository in a GitHub Workflow
  • Installing Multiple .NET Versions in GitHub Actions
  • Serving Images from Blob Storage in an Azure Function
  • Redis Caching in .NET
  • Passing Environment Variables From Docker to .NET Web App
Tag Cloud

.NET .NET Core AAD API ASP.NET Core Authentication Azure Azure Active Directory Azure Function Azure Storage Blob Bootstrap C# Console Application CSS DataTable Dependency Injection Dictionary Entity Framework Enum Extension Google GZip HTML Image JavaScript jQuery JSON List Middleware MVC Newtonsoft RestSharp Serilog SQL SSDT SSIS Stored Procedure Stream Table Table Storage Test Web App Web Application WordPress

Programming

Retrieving Data from MySQL Stored Procedures in .NET

We’re currently working on a .NET backend API project that retrieves data from a MySQL database and returns it to a frontend React app. As this is a migration project we’re working with a pre-existing MySQL database which given it’s currently supporting a live application we’re loath to make structural Read more…

By Shinigami, 1 year ago
Programming

Capturing MySQL Logs from a Docker Instance

If you’ve got a MySQL database running in Docker and you want to debug the calls being made to it you can enable logging and then export those logs to your desktop for investigation. First you need to enable logging in your MySQL database. Then if you trigger the action Read more…

By Shinigami, 1 year24 August 2022 ago
Uncategorised

Migrating a WordPress Site From Azure to AWS

I was previously hosting this site on a WebApp instance in Azure but partly due to cost reasons I decided to migrate it over to AWS. There’s a variety of guides available to help with parts of this but nothing that covers the full process so I figured I’d try Read more…

By Shinigami, 2 years ago
Azure

Azure Web App In App MySQL

If you’re setting up a WordPress site in an Azure Web App then an easy option for hosting the required MySQL database is to use the MySQL in app option of the Web App rather than setting up a new MySQL server. Though it’s worth noting that this isn’t very Read more…

By Shinigami, 5 years2 April 2019 ago
  • Facebook
  • Twitter
  • Instagram
  • Email
Hestia | Developed by ThemeIsle