User Tools

Site Tools


dump

Dump

Script per un dump da mysql

#! /bin/bash
 
host=localhost
db_name=database
user=root
password=root
port=3306
today=$(date --iso-8601)
 
dump_filename=${db_name}_${today}.sql
 
mysqldump -u${user} -h${host} --password=${password} --port=${port} --quick --max_allowed_packet=512M --skip-lock-tables ${db_name} > ${dump_filename}
dump.txt · Last modified: by gabriele