Blogs

Bash script to export all data from a MySQL/MariaDB database to CSV files: #!/bin/bash DB_USER="your_username" DB_PASS="your_password" DB_NAME="your_database" TABLES=$(mysql -u$DB_USER -p$DB_PASS -e "USE $DB_NAME; SHOW TABLES;" | grep -v "Tables_in") for TABLE in $TABLES; do mysql -u$DB_USER -p$DB_PASS -e "USE $DB_NAME; SELECT * FROM $TABLE;" | sed 's/\t/","/g;s/^/"/;s/$/"/' > "$TABLE.csv" done echo "CSV export complete!" Replace your_username, your_password, and your_database with your actual database credentials and database name. Save the script to a file, make it executable with chmod +x scriptname....

Step 1: Update Your System: Begin by ensuring your Ubuntu system is up to date. In the terminal, execute the following commands: sudo apt update sudo apt upgrade Step 2: Installing OpenJDK: Ubuntu’s default repositories offer convenient access to OpenJDK packages. For this guide, we’ll focus on OpenJDK 11, an LTS version. Install it using the package manager: sudo apt install openjdk-11-jdk Step 3: Verify the Installation: Once installation is complete, verify that Java is successfully installed by checking the version:...

Below is the Bash script to download and set up Nginx server with SSL using a self-signed certificate and user-provided details on RHEL (Red Hat Enterprise Linux): #!/bin/bash # Check if the script is running with root privileges if [ "$EUID" -ne 0 ]; then echo "Please run this script as root or with sudo." exit 1 fi # Check if a domain name is provided as an argument if [ $# -ne 1 ]; then echo "Usage: $0 <domain_name>" exit 1 fi # Assign the provided domain name to a variable domain_name="$1" # Prompt the user for SSL certificate details read -p "Enter the Country Code (e....

Below is a Bash script to download and set up Nginx server with SSL using a self-signed certificate and user-provided details: #!/bin/bash # Check if the script is running with root privileges if [ "$EUID" -ne 0 ]; then echo "Please run this script as root or with sudo." exit 1 fi # Check if a domain name is provided as an argument if [ $# -ne 1 ]; then echo "Usage: $0 <domain_name>" exit 1 fi # Assign the provided domain name to a variable domain_name="$1" # Prompt the user for SSL certificate details read -p "Enter the Country Code (e....

Setting up a Python virtual environment in Linux involves a few steps. Here’s a step-by-step guide: Open a terminal: Launch the terminal application on your Linux distribution. Install Python: Most Linux distributions come with Python pre-installed. However, if it’s not installed or you want a specific version, you can install it using your distribution’s package manager. For example, on Ubuntu or Debian-based systems, you can use the following command to install Python 3:...