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
Installation Bashtop an upgraded CLI system reporting interface from Top or Htop August 15, 2020 Install Bashtop Resource Monitor on Ubuntu You can use PPA repository for Ubuntu Linux installations: sudo add-apt-repository ppa:bashtop-monitor/bashtop sudo apt update sudo apt install bashtop Install Bashtop Resource Monitor on Debian For Debian and its based distributions, used the commands below: Related Read More
Copy files from computer to USB using linux command prompt February 2, 2009 Somebody lately, asked a silly simple thing- how can he copy files from his computer to usb and he’s using linux? Actually any novice can ask this simple thing- as GUI interface is already became quite mature than earlier and ppl naturally forgetting command consoles. Anyways, here goes it like… Read More
How to Allow MySQL Client to Connect to Remote MySQL server December 19, 2011 By default, MySQL does not allow remote clients to connect to the MySQL database. If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below. $ mysql -h… Read More