How to reboot a server in DigitalOcean
Posted by Alex On November 15, 2022
DigitalOcean offers various cloud technologies for developers, but of all the variety of services, I use only VPS (virtual private server). At the same time, due to the large number of cloud solutions, it is not intuitively clear how to perform such a simple action in DigitalOcean as rebooting the VPS. The server can be […]
ImageMagick error on Windows: “magick: unable to open image ''test': No such file or directory @ error/blob.c/OpenBlob/3565. magick: no decode delegate for this image format `' @ error/constitute.c/ReadImage/741.” (SOLVED)
Posted by Alex On November 3, 2022
If in Windows 11 open CMD: cmd And then run the command: magick '.\Для теста.jpg' test.png An error will be received that there is no such file or directory: magick: unable to open image ''.\╨Ф╨╗╤П': No such file or directory @ error/blob.c/OpenBlob/3565. magick: no decode delegate for this image format `' @ error/constitute.c/ReadImage/741. You can […]
Some program areas become transparent or invisible in guest OS Windows after upgrading to VirtualBox 7 (SOLVED)
Posted by Alex On October 26, 2022
The big update to VirtualBox 7 brought a lot of changes and, apparently, bugs. Some of them have already been covered in the post “Windows stopped booting in Virtual Machine after upgrading to VirtualBox 7 (SOLVED)”. While working with a guest OS Windows 11 in VirtualBox 7, new issues were discovered, some of which were […]
Error “The '<' operator is reserved for future use.” (SOLVED)
Posted by Alex On October 25, 2022
Analog “<” for PowerShell On Linux, you can use the following construct: COMMAND1 < FILE1 In this case, COMMAND1 will be executed with FILE1 as the input source instead of the keyboard, which is the normal standard input source. The “<” operator corresponds to the use of “|” to be passed to standard input. For […]
mysqldump in PowerShell corrupts non-Latin characters when exporting database (SOLVED)
Posted by Alex On October 23, 2022
mysqldump is a MySQL utility for creating database and table backups. Unlike phpMyAdmin, which, although it offers a web interface, is a slower tool due to the limitations of intermediates such as PHP and Apache, mysqldump is a much more efficient tool without limitations for backing up very large data. But on Windows, mysqldump has […]
Output encoding issues in PowerShell and third-party utilities running in PowerShell (SOLVED)
Posted by Alex On October 23, 2022
What encoding is used in PowerShell by default. How to change the default output encoding to UTF-8 in PowerShell If you run the following command in PowerShell 5: "Testing" > test.file And check the encoding in the newly created test.file, it turns out that it is UTF-16LE. If you run the following command in PowerShell […]
Windows stopped booting in Virtual Machine after upgrading to VirtualBox 7 (SOLVED)
Posted by Alex On October 22, 2022
After upgrading to VirtualBox 7 (more precisely, to VirtualBox 7.0.2), the Windows 11 guest OS stopped booting. Windows 11 guest boot starts as usual, no errors are displayed. Moreover, you can hear the Windows logon sound, but the desktop is not shown. Boot freezes on the initial screen with UEFI messages. As a host (main) […]
How to rename a table in phpMyAdmin and MySQL
Posted by Alex On October 21, 2022
How to rename a table in phpMyAdmin Open the database and then navigate to the table you want to rename. When the table is open, select the “Operations” menu item. Locate the “Move table to (database.table)” section. Yes, renaming uses the same function as moving a table to another database. Enter a new table name […]
phpMyAdmin error “Error: Undefined constant "SODIUM_CRYPTO_SECRETBOX_KEYBYTES"” (SOLVED)
Posted by Alex On October 20, 2022
On Arch Linux, when trying to use the phpMyAdmin 5.3 pre-release, I encountered an error: Error: Undefined constant "SODIUM_CRYPTO_SECRETBOX_KEYBYTES" Checking in Debian showed that there is no such problem with phpMyAdmin 5.3. The reason for the error is that sodium support is not enabled. How to enable sodium on Arch Linux (Manjaro, BlackArch) To enable […]
Sitemap.xml files: what they are for, how to use them, and how to bypass “Too many URLs” error and size limits
Posted by Alex On October 20, 2022
Table of contents What are Sitemaps What are the restrictions for sitemap files How can you compress a sitemap file Can I use multiple sitemaps? What is the structure of sitemap files How to generate sitemap files How to Import a Sitemap into Google Search Console Sitemap.xml file status “Couldn't fetch” Is it necessary to […]