> Hello MaxDB users,
>
> For a test environment I backup a MaxDB 7.6 database to a filesystem. I
> use a Backup Medium of:
> Backup Type: Complete Data
> Device Type: File
> Backup Tool: None
> Device/File: <filesystem/name>
>
> The volume of the test database is now around 50 GB and growing. It
> takes quite long to FTP or copy this backup file to an other place for
> security reasons. So I had an idea to make the backup to a pipe and then
> tar or zip the backup file before it is written to the filesystem.
>
> Is this possible and how can I configure this?
>
Hi,
The procedure is to create a pipe backup medium. Then create a FIFO with
the specifed filename, start the backup, and then start a reading process
which picks the data, compresses it and do what you want with the stream.
The script below should give you an idea how to do it.
Regards,
Simon
----%<-----------------------------------------------------
#!/bin/sh
###
# create MaxDB backup (sample script)
###
if [ "$(id -u)" = "0" ]; then
echo "don't start script as root " 1>&2
exit 1
fi
PATH=/opt/sdb/programs/bin:$PATH
export PATH
# name of the database
SID=TST76
dbmcli -d $SID -u dbm,dbm medium_put Pipe /tmp/maxdb-backup PIPE DATA
mknod /tmp/maxdb-backup p
dbmcli -d $SID -u dbm,dbm -uUTL -c backup_start Pipe &
cat /tmp/maxdb-backup | gzip -c | \
ssh backupserver "cat > /tmp/maxdb-backup.gz"
rm /tmp/maxdb-backup
----%<-----------------------------------------------------
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
