User Tools

Site Tools


dump

This is an old revision of the document!


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 --verbose ${db_name} > ${dump_filename}
dump.1787222937.txt.gz · Last modified: by gabriele