Large Database Import Progress Using PV Rumi, March 24, 2020 PV can report progress for large data imports. In this example I will use a large (7 G) install on Ubuntu. First, download PV (http://linux.die.net/man/1/pv) sudo apt-get install pv A traditional mysql import may be formatted as: mysql -u USER -p DATABASE_NAME < DUMP.mysql but to leverage PV, pass the dump file ,then pipe the mysql command specifying the database with -D flag: pv DUMP.mysql | mysql -u USER -p -D DATABASE_NAME Your import will report progress and an ETA 🙂 Related Administrations Configurations (Linux) MySQLPV
Install VirtualBox legacy version 5.x on CentOS 7 June 11, 2022 Install Dependencies Install Extra Packages for Enterprise Linux (EPEL) # sudo yum install epel-release wget -y Install Dynamic Kernel Module Support (DKMS) # sudo yum –enablerepo=epel install dkms -y This will install quite a few packages: Install Development Tools # sudo yum groupinstall “Development Tools” -y Related Read More
SOLVED Zimbra 8.6 HTTP ERROR 404 Problem accessing /public/error.jsp. Reason: /public/error.jsp May 10, 2019 Do a quick search under the usual jetty folders: find /opt/zimbra/jetty/ -type f -name *jsp -mtime -30 If you find files like: /opt/zimbra/jetty/webapps/zimbra/js/zimbra/csfe/XZimbra.jsp /opt/zimbra/jetty/webapps/zimbra/public/Ajax.jsp you’re actually hacked. Unlike the previous “zmcat” and “dblaunchs” that actually exploit the vuln and load some sh*t this looks like a bad childish attack. It… Read More
PXE Boot Server of CentOS 5 on a CentOS setup May 31, 2013 Setting up PXE Server Install some packages that is required for PXE server. [root@dlp ~]# yum -y install system-config-netboot syslinux xinetd tftp-server Run TFTP server [root@dlp ~]# vi /etc/xinetd.d/tftp # line 14: change disable =no [root@dlp ~]# /etc/rc.d/init.d/xinetd start Starting xinetd: [ OK ] [root@dlp ~]# chkconfig xinetd on Install… Read More