MysqlDump bash scripts

Posted 4 years ago - updated 3 years ago mysqldump bash

Create individual zip files from list:

#!/bin/bash

tables=(
 users
 permissons
 passwords
 products)

# item_screengrabs_data 

for f in "${strings[@]}"; do

do 
    echo "EXPORTING FILE: $f"
    mysqldump dome $f | gzip > $f.sql.gz

#    gunzip -c $f | mysql -h $DB_host -u $DB_user -p$DB_pass $DB

    (( file_count++ ))
done

Import files from directory:

for z in *.gz
do
  gunzip $z;
  SQL=${z%.*};
  echo ${SQL};
  mysql dome < "${SQL}";
done