MySQL: install, manage, backup, update, customize
I am running PHP on IIS 7.5. This is a Windows 2012 Server. Fresh clean install every time. The only way to access and delete these TEMP files are by using a command prompt. And this deletion procedure will run for several DAYS . . . The Problem The story […]
This was exciting. After years of neglect, I have decided to examine, who is registering on my WordPress site, and what is that they are doing. I knew that most of them are just a result of robot activities, and they are just a dead weight in the database (useless […]
Julian date is stored in YYYDDD format, for example 12/31/99 will be stored as 99365 and 01/01/2017 will be stored as 117001. If you need to convert the date from YYYDDD to any conventional date format like dd/mm/yyyy in SQL use steps below. The idea is to convert year and […]
Scenario Here is a recipe on how to concatenate a field from multiple records into one field. There are two pre-conditions for this method to work: First. Your source file needs to have an equivalent of a line number field. This should be a numeric field indicating the sequence in […]
Exciting voyage began on TU 2021-02-16. After months of WordPress (WP) warning about outdated PHP version, it was time to open a new Amazon Linux 2 instance and install all the latest gadgets. This major upgrade triggered many errors and problems. I needed a place to store and accumulate the […]
Task You already have a working WordPress (WP) site. Now, you need to add one more site with a new MySQL database. This document describes how to add one more database and install a new WP site on the same server. Download Download latest WordPress ZIP package (3.X) and unzip […]
If you connecting to a table using subquery, you might experience an error “Subquery returned more than 1 value“, that will crash your SQL. Here is an elegant and powerful solution that (1) cures the error and (2) allows to locate your desired row more precisely. For example, you […]
This article is about moving your Windows-based WordPress and other sites (some ASP, some ASP.NET) from older to a newer instance using AMAZON cloud server instances. Procedures described here do not involve any installation. Just copy files and edit CONFIG files. We do not manipulate Registry as well (except to change […]
2018-07-18 WE Problem/ Question: There are situations, when you need to change topic position in the list of other topics in the forum. Where bbPress (WordPress plugin) stores the values to sort topics display order? Plan of action: – Determine topic ID – Update bbPress topic freshness recorded somewhere in […]
How to update MySQL Server on Windows Machine Preliminary notes: These steps work for MySQL Server that is running as a service on Windows machine. These steps were tested, when MySQL data directory is located on a different drive from MySQL installation directory. Determine your current MySQL version. […]
I hope this long title will help to find this solution faster.Finally, in December 2019 I had time to work on SQL cumulative total.Let’s start with an example: WITH STORE_COUNTS AS ( SELECT ROW_NUMBER() OVER (ORDER BY CDCO) [RowNum],CDCO, COUNT(*) [COUNT] […]
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor