Posts tagged “mysqldump” — Sean Behan

Jun 2011 · 1 min read

Backup and Rotate MySQL Databases Simple Bash Script

Make a directory ( it can anywhere ) called baks/mysql mkdir -p /baks/mysql Create a file (it can be anywhere) called /root/mysqlbackups.sh and put this script in it !/bin/bash modify the following...

backups bash cron data mysql mysqldump scripting shell databases linux
Feb 2010 · 1 min read

Dump MySQL Database without Drop Table Syntax

Output .sql file for MySQL but without the drop table syntax before table name use the --skip-add-drop-table flag

databases flags mysql mysqldump syntax