How to check the integrity of a file transferred over the network in Linux and Windows
Posted by Alex On August 18, 2024
When you need to download or upload large files, you need to check their integrity. For example, when uploading a large file to a hosting or downloading an archive with a backup copy of sites, you need to transfer files of several gigabytes or even tens of gigabytes between computers. With a slow Internet connection […]
How to check if a SQL query result is empty or not empty in PHP
Posted by Alex On August 18, 2024
When executing a SQL query to a database, the rows and columns of a table can be returned as the execution result. An empty value can also be returned if no data matching the query is found in the table. The usual algorithm for processing the received response from the database is to fetch the […]
How to clear a List in Python. Why clearing a List deletes copies of it in other variables
Posted by Alex On August 18, 2024
Why clearing a List in Python deletes copies of it in other variables Clearing a list in Python can be done in a number of ways, some of which can lead to unexpected results if you don't know the differences and what's going on under the hood. Let's look at a very simple script that […]
How to find the third root in Linux. How to extract a root of any degree in Linux
Posted by Alex On August 17, 2024
Table of contents 1. How to extract a cube root in Linux 2. How to find a cube root in the Linux calculator (GNOME Scientific calculator) 3. How to find a root of any degree in the Linux calculator (GNOME Scientific calculator) 4. How to extract a root of any degree in the command line […]
How to find rows with empty column value in MySQL/MariaDB table (in phpMyAdmin and in command line)
Posted by Alex On August 16, 2024
How to find rows with empty column value in phpMyAdmin Suppose you want to find rows in a table where the value of a certain column is empty. To do this, you try to use the table search in phpMyAdmin. If you go to the “Search” tab in phpMyAdmin and click the “Go” button without […]
How to copy a table in MySQL/MariaDB
Posted by Alex On August 14, 2024
Backup a table in the same database This article will tell you how to make a copy of a table in the MySQL/MariaDB command line interface. Usually, backups of databases and tables are saved to files, but let's consider a situation when you need to duplicate or clone data, structure and indexes of tables in […]
How to copy a table in phpMyAdmin
Posted by Alex On August 14, 2024
Backup of a table in the same database This article will tell you how to make a copy of a table in phpMyAdmin. Usually, backups of databases and tables are saved to files, but let's consider a situation when you need to duplicate or clone data, structure and indexes of tables in the same or […]
PHP regular expressions don't work with very long strings (SOLVED)
Posted by Alex On August 13, 2024
preg_replace, preg_match_all, and preg_match functions don't work with long strings When trying to search in PHP using regular expressions using preg_replace, preg_match_all, and preg_match (or other regular expression search functions), the following problem may occur: the string being searched for exactly contains a substring that matches the search pattern; but instead of outputting the matched […]
SSD is very slow in Linux. How to check and enable TRIM in Linux (SOLVED)
Posted by Alex On August 11, 2024
If your SSD initially showed high performance, but over time it has become noticeably slower to read and write data, or periodically the read and write speed of the SSD drops sharply, then this article can help you. For SSD drives, it is necessary to perform the Trim operation and it is not enabled by […]
How to delete Wi-Fi network settings in Linux
Posted by Alex On August 8, 2024
Table of contents 1. Deleting Wi-Fi network settings in Linux 2. How to delete Wi-Fi settings in Linux Mint (Cinnamon) 3. How to delete Wi-Fi settings in Ubuntu and Kali Linux (GNOME 3) 4. How to delete Wi-Fi settings in Xubuntu (Xfce) 5. How to remove Wi-Fi settings in Kubuntu and Manjaro (KDE) 6. How […]