nezarjhons · December 6, 2021 04:57
diff --git a/README.md b/README.md
diff --git a/backupDB.sh b/backupDB.sh
 #!/bin/bash
 # Backup database from console
 DATABASE=
 DEFAULTS_FILE=$DATABASE.cnf
 BACKUP_DIR=
 LOGS_DIR=

 DB_OUT_FILENAME=$DEFAULTS_FILE-`date +\%Y\%m\%d`.sql.gz
 mysqldump --defaults-extra-file=$DEFAULTS_FILE $DATABASE 2>> $LOGS_DIR/$DATABASE.log | gzip - > $BACKUP_DIR/$DB_OUT_FILENAME
diff --git a/MYDB.cnf b/MYDB.cnf
 [client]
 host=
 user=
 password=

diff --git a/truncateTables.sh b/truncateTables.sh
 #!/bin/bash
 # Truncate database tables from console
 DATABASE=
 DEFAULTS_FILE=$DATABASE.cnf

 mysql --defaults-extra-file="$DEFAULTS_FILE" -Nse 'show tables' $DATABASE | while read table; do mysql --defaults-extra-file="$DEFAULTS_FILE" -e "truncate table $table" $DATABASE; done
	#!/bin/bash
	# Backup database from console
	DATABASE=
	DEFAULTS_FILE=$DATABASE.cnf
	BACKUP_DIR=
	LOGS_DIR=

	DB_OUT_FILENAME=$DEFAULTS_FILE-`date +\%Y\%m\%d`.sql.gz
	mysqldump --defaults-extra-file=$DEFAULTS_FILE $DATABASE 2>> $LOGS_DIR/$DATABASE.log \| gzip - > $BACKUP_DIR/$DB_OUT_FILENAME
	#!/bin/bash
	# Truncate database tables from console
	DATABASE=
	DEFAULTS_FILE=$DATABASE.cnf

	mysql --defaults-extra-file="$DEFAULTS_FILE" -Nse 'show tables' $DATABASE \| while read table; do mysql --defaults-extra-file="$DEFAULTS_FILE" -e "truncate table $table" $DATABASE; done