MySQL: install, manage, backup, update, customize
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] […]
Locate your MySQL installation files and central configuration file basedir=”C:/Program Files/MySQL/MySQL Server 5.1/” Your MySQL configuration is stored in “my.ini” file Locate your MySQL Database location: datadir=”C:/Documents and Settings/All Users/ Application Data/MySQL/MySQL Server 5.1/Data/” Stop MySQL service. Modify My.ini file to point to a new D/B location and Save. Move […]
This article was born, as I was searching for ways to handle thousands of registered WordPress users, who never do anything, never return to the site, and never even change their default password. Table of Topics -1030- List all registered users sorted by date -1060- Group registered users […]
Say, you need to get a single top order number from a related table. You might use this TOP 1 syntax: , ISNULL((SELECT TOP 1 D1.CDDOCO FROM CRPDTA.F1721 D1 WHERE D1.CDNUMB = FANUMB AND D1.CDCDTE > @TODAY ORDER BY D1.CDDOCO DESC), ”) [Top contract] However, if your output returns over […]
This article is written for those who need to test/evaluate features of new WordPress release on a local machine before rolling it out to all the serves. This article describes running PHP on IIS 7.5 through FastCGI. For best results, reader is required to be able to start and stop […]
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor