MyDumper - Revision history

Jan: 1 revision imported

2016-08-26T19:10:42Z

1 revision imported

← Older revision

Revision as of 21:10, 26 August 2016

Jan: 1 revision imported

2016-08-26T19:09:41Z

1 revision imported

← Older revision

Revision as of 21:09, 26 August 2016

Jan at 19:17, 9 January 2016

2016-01-09T19:17:37Z

← Older revision		Revision as of 21:17, 9 January 2016
Line 15:		Line 15:
	DB=$(basename "${DBFILE}" \| sed 's/_schema\.sql\.gz//')		DB=$(basename "${DBFILE}" \| sed 's/_schema\.sql\.gz//')
	echo "Restoring schema for database '${DB}' from ${DBFILE}"		echo "Restoring schema for database '${DB}' from ${DBFILE}"
	# zcat ${DBFILE} \| mysql ${DB}		zcat ${DBFILE} \| mysql ${DB}
	for TFILE in $(find ${1} -iname "${DB}.*.sql.gz"); do		for TFILE in $(find ${1} -iname "${DB}.*.sql.gz"); do
	TABLE=$(basename "${TFILE}" \| sed -n "s/${DB}\.$.*$\.sql\.gz/\1/p")		TABLE=$(basename "${TFILE}" \| sed -n "s/${DB}\.$.*$\.sql\.gz/\1/p")

Jan: Created page with "== Restore == #!/bin/bash if [ -z $1 ]; then echo "Usage: $0 [database-name]" exit 1 fi FINDNAME="*" if [ -n ${2} ]; then FINDNAME=..."

2016-01-09T19:17:21Z

Created page with "== Restore == <nowiki>#!/bin/bash if [ -z $1 ]; then echo "Usage: $0 </path/to/mydumper/backup> [database-name]" exit 1 fi FINDNAME="*" if [ -n ${2} ]; then FINDNAME=..."

New page

== Restore ==
<nowiki>#!/bin/bash

if [ -z $1 ]; then
echo "Usage: $0 </path/to/mydumper/backup> [database-name]"
exit 1
fi

FINDNAME="*"
if [ -n ${2} ]; then
FINDNAME="${2}"
fi

for DBFILE in $(find ${1} -iname "${FINDNAME}_schema.sql.gz"); do
DB=$(basename "${DBFILE}" | sed 's/_schema\.sql\.gz//')
echo "Restoring schema for database '${DB}' from ${DBFILE}"
# zcat ${DBFILE} | mysql ${DB}
for TFILE in $(find ${1} -iname "${DB}.*.sql.gz"); do
TABLE=$(basename "${TFILE}" | sed -n "s/${DB}\.$.*$\.sql\.gz/\1/p")
echo "Restoring table ${DB}.${TABLE}..."
zcat ${TFILE} | mysql ${DB}
done
done
</nowiki>