lhotakj

  
  use `<< database name >>`;
  SET FOREIGN_KEY_CHECKS = 0; 
  SET @tables = NULL;
  SET GROUP_CONCAT_MAX_LEN=32768;

  SELECT GROUP_CONCAT('`', table_schema, '`.`', table_name, '`') INTO @tables
  FROM   information_schema.tables 
  WHERE  table_schema = (SELECT DATABASE());
  SELECT IFNULL(@tables, '') INTO @tables;

lhotakj

# https://linuxhint.com/install_python3_centos7/
# https://tecadmin.net/install-python-3-7-on-centos/
# alt
cd /tmp
sudo yum groupinstall -y "Development Tools"
wget https://www.python.org/ftp/python/3.7.1/Python-3.7.1.tar.xz
tar -xJf Python-3.7.1.tar.xz
cd Python-3.7.1
./configure
make

lhotakj

list all NFS ports:
rpcinfo -p | awk '{print $3" "$4}' | sort -k2n | uniq


#edit  https://www.cyberciti.biz/faq/centos-fedora-rhel-iptables-open-nfs-server-ports/

sudo firewall-cmd --zone=public --permanent --add-port=111/tcp
sudo firewall-cmd --zone=public --permanent --add-port=111/udp
sudo firewall-cmd --zone=public --permanent --add-port=2049/udp
sudo firewall-cmd --zone=public --permanent --add-port=2049/tcp

lhotakj

sudo apt-get update -y
sudo apt-get install python3.6 -y
sudo apt-get install software-properties-common -y
sudo add-apt-repository ppa:deadsnakes/ppa
sudo apt-get update -y
sudo apt-get install python3.6 -y
sudo apt install python3-pip -y
# go to /usr/bin and edit pip3 to point to 3.6