|
Lines 79-91
dump_instance()
Link Here
|
| 79 |
then |
79 |
then |
| 80 |
schemadump="$backupdir/$name-schema-$date.sql" |
80 |
schemadump="$backupdir/$name-schema-$date.sql" |
| 81 |
[ "$quiet" = "no" ] && echo "* schema to $schemadump" |
81 |
[ "$quiet" = "no" ] && echo "* schema to $schemadump" |
| 82 |
mysqldump $dbflag -d --host="$mysqlhost" \ |
82 |
mysqldump $dbflag -d --host="$mysqlhost" --single-transaction \ |
| 83 |
--user="$mysqluser" --password="$mysqlpass" "$mysqldb" | sed --expression='s/ AUTO_INCREMENT=[0-9]\+//' > "$schemadump" |
83 |
--user="$mysqluser" --password="$mysqlpass" "$mysqldb" | sed --expression='s/ AUTO_INCREMENT=[0-9]\+//' > "$schemadump" |
| 84 |
chown "root:$name-koha" "$schemadump" |
84 |
chown "root:$name-koha" "$schemadump" |
| 85 |
chmod g+r "$schemadump" |
85 |
chmod g+r "$schemadump" |
| 86 |
else |
86 |
else |
| 87 |
[ "$quiet" = "no" ] && echo "* DB to $dbdump" |
87 |
[ "$quiet" = "no" ] && echo "* DB to $dbdump" |
| 88 |
mysqldump $dbflag --host="$mysqlhost" \ |
88 |
mysqldump $dbflag --host="$mysqlhost" --single-transaction \ |
| 89 |
--user="$mysqluser" --password="$mysqlpass" "$mysqldb" | |
89 |
--user="$mysqluser" --password="$mysqlpass" "$mysqldb" | |
| 90 |
gzip > "$dbdump" |
90 |
gzip > "$dbdump" |
| 91 |
chown "root:$name-koha" "$dbdump" |
91 |
chown "root:$name-koha" "$dbdump" |
| 92 |
- |
|
|