For example, update the MySQL server from version 5.5 to 5.7.
Before performing an update, it is imperative that you make backup copies of all databases, including the standard ones.
Category Archives: Linux
Recovering MySQL InnoDB after power failure
Once, after the power was turned off, the UPS was discharged, then the generator automatic start did not work because it turned on and off several times, as a result, the server with MySQL was also started and disconnected from the power supply several times, later the tables of different databases were damaged , including the default database with mysql users, as a result, the MySQL daemon did not start.
Continue reading “Recovering MySQL InnoDB after power failure”Logrotate Bind9
Suppose Bind9 logs are written to the /var/log/named/ directory, have the .log extension and so that the disk space does not overflow with logs, configure logrotate.
Continue reading “Logrotate Bind9”How to roll back the kernel version on Ubuntu
Sometimes after updating the kernel of the system, some important services start to work incorrectly and in order not to look for a problem on the combat server, and to do it for example later on the virtual one, you can boot the system from the previous version of the kernel.
Continue reading “How to roll back the kernel version on Ubuntu”Why is the GRUB installed on a flash drive when installing Linux?
By default, the GRUB boot loader is installed on the first disk in the system, it is usually a hard disk, but on some servers with RAID controllers I noticed that when you turn on the server, select the USB flash drive in the Boot menu, of course, to boot from it, it becomes the first disk, then there is /dev/sda and at the end of the system installation the bootloader is installed on it.
Continue reading “Why is the GRUB installed on a flash drive when installing Linux?”Installing and configuring Logwatch
In this article I will give an example of installing Logwatch.
Installation command in Ubuntu/Debian:
Installing Graylog on Ubuntu
Graylog – open source software with a web interface for collecting and viewing logs, at the time of this writing, free of charge up to the limit of data collected is 5 GB per day.
Continue reading “Installing Graylog on Ubuntu”Installing and using the Wondershaper
WonderShaper is software for Linux that allows you to limit the speed of data transmission and reception on network interfaces, suitable for home or office computers.
Continue reading “Installing and using the Wondershaper”Abills. Solving the error Cannot change column ‘id’: used in a foreign key constraint ‘users_contacts_ibfk_2’
Once executed db_check.pl on a server with Abills 0.78.16:
Continue reading “Abills. Solving the error Cannot change column ‘id’: used in a foreign key constraint ‘users_contacts_ibfk_2’”How to solve “Extension mysqli | mysql not found”
I noticed once on one of the new Ubuntu servers an error when opening phpMyAdmin – “The extension mysqli | mysql not found.”
Continue reading “How to solve “Extension mysqli | mysql not found””