Importing Big mysqldump with Progress Bar PV Rumi, December 12, 2013 I am using CentOS 6.4 box, so it requires me to install EPEL repo at the first place: $ rpm -Uhv http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm Install pv using yum: $ yum install -y pv Installation done. Let the importing begin! $ pv /home/user/my_big_dump.sql | mysql -uroot -p For Ubuntu/Debian distribution intall PV using- apt-get install pv Related Administrations Configurations (Linux) MySQLMySQLDumpPV
How To Install and Use Docker Compose on Rocky Linux 8 February 7, 2024 Step 1 — Installing Docker The Docker installation package available in the official Rocky Linux 8 repository may not be the latest version. To get the latest and greatest version, install Docker from the official Docker repository. This section shows you how to do just that. But first, let’s update… Read More
Disable gpgcheck while running updates January 12, 2024 Problem Statement: # su -c ‘yum install *.rpm’ which produced a long list of packages and depchecks, apparently successfully, but then gave: Install 50 Package(s) Total size: 436 M Installed size: 436 M Is this ok [y/N]: y Downloading Packages: Package libobasis3.3-en-US-base-3.3.0-6.x86_64.rpm is not signed [dave at davehost RPMS]$ Resolution:… Read More
Install and configure fail2ban January 4, 2015 Servers do not exist in isolation, and those servers with only the most basic SSH configuration can be vulnerable to brute force attacks. fail2ban provides a way to automatically protect the server from malicious signs. The program works by scanning through log files and reacting to offending actions such as… Read More