MySQL: install, manage, backup, update, customize
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 […]
If you like to be in control of all your servers, you would love the gentle nature of WordPress installation. Installation includes PHP, MySQL and WordPress components. All steps can be done manually. Instead of running install, you can just copy files and directories, and make manual configurations adjustments. It […]
If you ever need to transfer your own installation of WordPress from machine to machine, you might need these notes. How to configure a new WordPress install on a new PC and copy My-SQL D/B file. […]
Question: Each time I modify a POST, a copy of old POST is created and saved. Can I control, how many old posts to retain? Can I clean all old posts? Answer: Yes! You can stop collecting old versions of the posts by adding this line to your wp-config.php file: define(‘WP_POST_REVISIONS’, […]
I just installed WordPress with MySQL. I am familiar with all the intricacies of SQL Query. I am asking from MS SQL Admin point of view. These questions from a person who never saw MySQL before: – Where DB files are located? – See other post – Is DB backup available and […]
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor