Personal Blog
Posts
-
How to import CSV file into mysql database using commmand line (terminal)
Import large CSV file using command line rather than using phpMyAdmin or other GUI software. Importing CSV file using command line is much faster, you can import 100000+ rows in seconds which is not possible in phpMyAdmin. Table name should be same as the CSV file name. Use this command in your command line. Please…
-
Fix MongoDB port for remote access in iptables [firewalld] ubuntu
Just add 27017/tcp to iptable and it will work! sudo firewall-cmd –zone=public –add-port=27017/tcp –permanent sudo firewall-cmd –reload Check using: sudo iptables -L -v and/or sudo firewall-cmd –list-ports Check if firewalld is running: sudo systemctl status firewalld tested on: ubuntu: 22.04.1 LTS Make sure you have disable ufw: sudo ufw disable Errors: E-1: connect ECONNREFUSED…
-
HTML vs. PHP: What’s the difference and Which one should I choose?
What they are meant for? HTML and PHP are two different things meant for two different task. As far as HTML (Hypertext Markup Language) is concerned, HTML (along with CSS) is a backbone of all the web-development and used as a front end development whereas PHP (Hypertext Preprocessor) is a server side scripting language which execute…
-
Chrome With New Avatar: The New Material Theme
Chrome has started offering new Material Skin for the browser but it is not available as an option visible in the settings yet. You need to enable it through the Chrome Flags. It is still in the beta version and you might face some bugs while using it. But, Google will fix them accordingly. Firstly,…