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
Disable swap in Linux February 24, 2020 Identify configured swap devices and files with cat /proc/swaps. Turn off all swap devices and files with swapoff -a. Remove any matching reference found in /etc/fstab. Optional: Destroy any swap devices or files found in step 1 to prevent their reuse. Due to your concerns about leaking sensitive information, you… Read More
Postfix to allow Mail Relay from a Trusted IP May 27, 2023 Make sure smtpd_recipient_restrictions has permit_mynetworks, something like this: smtpd_recipient_restrictions = permit_mynetworks,<more> This is the default, but if you have -o smtpd_recipient_restrictions=something on an smtpd line in master.cf then it will override main.cf setting. A sample configuration that worked for me is as below- smtp inet n – n – -… Read More
Install Zabbix Agent on Ubuntu 20.04 June 21, 2023 Zabbix agent is installed on the remote host (target) to monitor the hard drive, memory processor, etc. The agent collects data and sends back to Zabbix Server. Zabbix agents can use passive or active checks to pass information. In passive check, Zabbix server (poller) requests an agent for certain information, and the agent sends back a… Read More