How to Disable the ONLY_FULL_GROUP_BY Mode in MySQL

Jak vypnout mód ONLY_FULL_GROUP_BY v MySQL

MySQL is a popular relational database management system widely used in the field of IT. MySQL offers the ability to work with data using the SQL language, which is used for data manipulation and various operations. These operations include data insertion, updating, reading, and deletion. In this article, we will explore how to disable the ONLY_FULL_GROUP_BY mode in MySQL. This can be achieved by using a command in the connection script. How to Disable the ONLY_FULL_GROUP_BY Mode in MySQL The ONLY_FULL_GROUP_BY mode in MySQL affects the behavior of SQL queries. To understand what this mode … Read more

MySQL backup on Linux – How to easily automate it?

Automatické zálohování MySQL na Linuxu

If you manage a Linux server that also runs MySQL databases, you might have wondered how to efficiently back up your database(s). Let’s take a look at automatic MySQL backup on Linux using commands and the CRON scheduler. This will allow us to create a schedule for automatic MySQL backups every night, saving them to SQL files, while also deleting backups older than 30 days. The result will be that a local backup of the database(s) will be created on the server, with backups available for up to one month. It’s important to note that … Read more

What is SSH or secure computer interconnection

Co je to SSH aneb bezpečné propojení počítačů v IT světě

Do you know what is SSH or secure computer interconnection? It stands for Secure Shell, which is a secure protocol used for communication and connection between computers over the internet. The purpose of SSH is to enable remote access to another computer. This means you can connect to and work with another computer even if you are physically distant from it. This is useful, for example, for server administration or remote technical support. What is SSH or secure computer interconnection SSH utilizes asymmetric encryption methods. This means that two keys are generated: a public key … Read more

RDP and remote access to computers

RDP a vzdálený přístup k počítačům

Do you know what RDP and remote access to computers are? RDP stands for Remote Desktop Protocol, which is a technology that enables remote access to computers. RDP, or Remote Desktop Protocol, is a secure communication protocol developed by Microsoft. Its purpose is to provide the capability to control another computer or server on a network from your own computer, even if you are physically distant from it. Such remote server control is useful, for example, for server administration and IT support. With RDP, you can access a remote computer, work with it, run applications, … Read more

Why is it better to avoid lazy load on WordPress?

Proč se raději na WordPressu vyhnout lazy loadu

Lazy load is a technique that allows you to deceive metrics for measuring the speed of your website. It works on the principle that images on the website are loaded only when they are about to be displayed to the user. This can result in better results shown by tools like Pagespeed Insight or GTmetrix. But is lazy load really a good thing for the website? Let’s take a look at the topic from the opposite perspective and discuss why is it better to avoid lazy load on WordPress. It has its reasons. Why is … Read more

Pokud mi chcete napsat rychlou zprávu, využije, prosím, níže uvedený
kontaktní formulář. Děkuji.

Další Kontaktní údaje