Learn How To Deleting Content From A MySQL Database

Kompletní návod na smazání obsahu MySQL databáze

Sometimes, you may find yourself in a situation where you need to delete the content of a database for various reasons. It can happen, for example, when you decide to delete an old website and build a new one, or when you want to replace the current data in the database with a backup. If you’re unsure how to proceed, you can follow this complete guide. The topic of today’s article is “learn how to deleting content from a MySQL database“. We will learn it gradually, step by step. Learn How To Deleting Content From … Read more

Sorry You are not Allowed to Upload this File Type

Jak můžu ve WordPressu nahrát nepovolený typ souboru?

Are you using the WordPress content management system on your website? You probably know that for enhanced security reasons, it only allows uploading certain file types. These typically include files commonly used in computer work, such as images, documents, or videos. Unfortunately, any other less typical file formats are prohibited by default in WordPress and need to be manually enabled. If you have ever encountered the error message “Sorry You are not Allowed to Upload this File Type,” you are in the right place. Let’s take a look at how to handle it. Sorry You … Read more

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

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

Další Kontaktní údaje