Ubuntu 20.04 Top Sudo Commands

Retrieve a list of all packages that can be upgraded

apt list --upgradable

Upgrade all Packages with updates

sudo apt upgrade

Update to the newest release

do-release-upgrade

Reboot System

 sudo reboot

Call Certbot for SSL install

sudo certbot

Disable Firewall

sudo ufw disable

Access MYSQL via Root with Password

mysql -u root -p

Restart MYSQL

sudo systemctl restart mysql.service

Get MYSQL Version and Packages mysql

mysql --version and/or dpkg --get-selections | grep sql

Stop MYSQL

 sudo systemctl stop mysql

Start MYSQL

sudo systemctl start mysql

Change PHP Versions

sudo a2dismod php8.1
sudo a2enmod php8.0

Change PHP Versions from Config

sudo update-alternatives --config php

Install PHP & Mods

sudo apt install php7.4
sudo apt-get install -y php7.4-cli php7.4-json php7.4-common php7.4-mysql php7.4-zip php7.4-gd php7.4-mbstring php7.4-curl php7.4-xml php7.4-bcmath

Install PHP & MBstring

sudo apt install php7.4-gettext php7.4-mbstring

Enable PHP Version

sudo a2enmod php8.0 
sudo systemctl restart apache2

Check Apache PHP Version

php -c /etc/php/apache2/php.ini -v

Restart Apache2

sudo systemctl restart apache2

Start Apache2

sudo systemctl start apache2

Check PHP Version

php --version

Check PHPMYADMIN Version

dpkg -l phpmyadmin

Export MYSQL Database

mysqldump -uUSERNAME -p DB_NAME > exported.sql

Import MYSQL Database 3 Steps

$ mysql -uUSERNAME -p;
mysql> CREATE DATABASE DB_NAME;
$ mysql -uUSERNAME -p DB_NAME < import_file.sql

Download all MYSQL Databases using Password and Dumping the File at /var/www/ directory

sudo mysqldump -u [username] -p --all-databases > /var/www/all_databases.sql

For exporting each database into separate files in a new directory you created.

sudo mkdir /var/www/mysql_backups  # Create a directory to store individual backups

for db in $(sudo mysql -u [username] -p -e 'show databases' -s --skip-column-names); do
    sudo mysqldump -u [username] -p $db > /var/www/mysql_backups/${db}.sql
done