MySQL: install, manage, backup, update, customize
You have several instances of SQL Server (Express) installed and you need to remove/uninstall just one of the instances. Here are the steps tested in Windows 10 with SQL Server 2019 Express —01— Open App & Features —02— Find MS SQL Server 2019 (64-bit) and click Uninstall: —03— Confirm […]
This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List […]
After synchronizing your laptop with corporate policies you might notice that multiple black command windows will popup on a regular basis that might even look like some virus. You are in luck if you hade ADMIN rights on your laptop. You can easily go to registry and delete all references […]
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 […]
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