Tag Archives: Database

#!/bin/bash function SqlDumpData { mysqldump -u secret -psecret –no-create-info –skip-opt –comments=0 $1| egrep -v “INSERT INTO `(accesslog|cache|search_index|sessions)`” | sort >$2 }

function SqlDumpStructure { mysqldump -u secret -psecret –no-data $1 >$2 } cd /home/user/DatabaseDumps SqlDumpData petersblog … Continue reading →