Skip to content
GitLab
Explore
Sign in
Primary navigation
Search or go to…
Project
C
compose.libre.sh
Manage
Activity
Members
Labels
Plan
Issues
18
Issue boards
Milestones
Wiki
Code
Merge requests
3
Repository
Branches
Commits
Tags
Repository graph
Compare revisions
Snippets
Build
Pipelines
Jobs
Pipeline schedules
Artifacts
Deploy
Releases
Model registry
Operate
Environments
Monitor
Incidents
Analyze
Value stream analytics
Contributor analytics
CI/CD analytics
Repository analytics
Model experiments
Help
Help
Support
GitLab documentation
Compare GitLab plans
Community forum
Contribute to GitLab
Provide feedback
Keyboard shortcuts
?
Snippets
Groups
Projects
Show more breadcrumbs
libre.sh
compose.libre.sh
Merge requests
!186
WIP: Resolve "Restore from legacy backup"
Code
Review changes
Check out branch
Download
Patches
Plain diff
Open
WIP: Resolve "Restore from legacy backup"
182-restore-from-legacy-backup
into
master
Overview
0
Commits
27
Pipelines
0
Changes
2
Open
Michel Memeteau
requested to merge
182-restore-from-legacy-backup
into
master
5 years ago
Overview
0
Commits
27
Pipelines
0
Changes
2
Expand
Closes
#182
👍
0
👎
0
Merge request reports
Compare
version 12
version 25
2aa5533f
4 years ago
version 24
8b76c40b
5 years ago
version 23
0d540b31
5 years ago
version 22
7982630f
5 years ago
version 21
55172604
5 years ago
version 20
efd17904
5 years ago
version 19
02e9c4e4
5 years ago
version 18
a4d0cb56
5 years ago
version 17
347b908e
5 years ago
version 16
e52c56fc
5 years ago
version 15
88537955
5 years ago
version 14
00b54763
5 years ago
version 13
09e870fa
5 years ago
version 12
f2cdc47f
5 years ago
version 11
9c776c61
5 years ago
version 10
870aa075
5 years ago
version 9
43df4a25
5 years ago
version 8
31a6d4e4
5 years ago
version 7
1dc1cfba
5 years ago
version 6
d5752560
5 years ago
version 5
039e061b
5 years ago
version 4
93eee0cd
5 years ago
version 3
d7f80c0d
5 years ago
version 2
c25853d9
5 years ago
version 1
3f9e425b
5 years ago
master (HEAD)
and
version 23
latest version
ac957df0
27 commits,
4 years ago
version 25
2aa5533f
26 commits,
4 years ago
version 24
8b76c40b
25 commits,
5 years ago
version 23
0d540b31
24 commits,
5 years ago
version 22
7982630f
23 commits,
5 years ago
version 21
55172604
22 commits,
5 years ago
version 20
efd17904
21 commits,
5 years ago
version 19
02e9c4e4
20 commits,
5 years ago
version 18
a4d0cb56
19 commits,
5 years ago
version 17
347b908e
18 commits,
5 years ago
version 16
e52c56fc
17 commits,
5 years ago
version 15
88537955
16 commits,
5 years ago
version 14
00b54763
15 commits,
5 years ago
version 13
09e870fa
14 commits,
5 years ago
version 12
f2cdc47f
13 commits,
5 years ago
version 11
9c776c61
12 commits,
5 years ago
version 10
870aa075
11 commits,
5 years ago
version 9
43df4a25
10 commits,
5 years ago
version 8
31a6d4e4
8 commits,
5 years ago
version 7
1dc1cfba
7 commits,
5 years ago
version 6
d5752560
6 commits,
5 years ago
version 5
039e061b
5 commits,
5 years ago
version 4
93eee0cd
4 commits,
5 years ago
version 3
d7f80c0d
3 commits,
5 years ago
version 2
c25853d9
2 commits,
5 years ago
version 1
3f9e425b
1 commit,
5 years ago
Show latest version
2 files
+
160
−
70
Inline
Compare changes
Side-by-side
Inline
Show whitespace changes
Show one file at a time
Files
2
Search (e.g. *.vue) (Ctrl+P)
utils/backup_app.sh
+
20
−
20
Options
#!/bin/bash
#=== Informations ================================================================
===
#
#-
B
ackup App (Piwigo, prestashop, nextcloud) database and data files
#=== Informations ================================================================#
#-
Goal: b
ackup App (Piwigo, prestashop, nextcloud) database and data files
#- Author: B. Mauclaire - bm@ekimia.fr - 2019/11/11
#- Author: M. Memeteau - mm@ekimia.fr - 2020/01/01
#- Licence: GNU Affero General Public License v3.0
#- Note: vm archive's name will be built with the app's name.
#- Warning: sshpass package has to be installed.
#--- Example of connexion parameters:
# HOST_NAME='jaguar.ekimia.fr'
# HOST_USER='root'
# HOST_PORT=622
# DB_NAME='piwigo'
# DB_USER='piwigo'
#-- File where host user's password is stored during script is runnung:
PSWDFILE
=
".nopaswd"
@@ -59,7 +52,9 @@ function main_proc ()
#--- Command for testing not asking ssh connexion password:
function
testsshnopass
()
{
sshpass
-p
`
cat
$PSWDFILE
`
ssh
-p
$HOST_PORT
${
HOST_USER
}
@
$HOST_NAME
"ls"
sudo
apt
install
sshpass
-y
}
@@ -70,11 +65,12 @@ function set_app_directories ()
piwigo
)
#-- i=photos/_data/i ; upload=photos/upload
APP_DIR
=
"/var/www/photos"
;
APP_DIRS
=(
"_data/i"
"upload"
)
;
APP_DIRS
=(
"_data/i"
"upload"
"local/config"
)
;
;;
prestashop
)
APP_DIR
=
"/var/www/html"
;
APP_DIRS
=(
""
)
;
# See for 1.7 https://devdocs.prestashop.com/1.7/development/architecture/
APP_DIR
=
"/var/www/"
;
APP_DIRS
=(
"shop"
)
;
;;
nextcloud
)
APP_DIR
=
""
;
@@ -131,14 +127,18 @@ function backup_db ()
{
echo
""
echo
"*** Database backup from
$HOST_NAME
to local file
${
DB_NAME
}
.sql ***"
if
[
"
$DB_ENGINE
"
==
"mysql"
]
||
[
"
$DB_ENGINE
"
==
"mariadb"
]
;
then
$SSHNOPASS
"mysqldump '"
$DB_NAME
"' -u '"
$DB_USER
"' -p'"
${
DB_PWD
}
"'"
>
${
DB_NAME
}
.sql
elif
[
"
$DB_ENGINE
"
==
"pgsql"
]
;
then
# !! TO TEST !!
$SSHNOPASS
"PGPASSWORD='"
${
DB_PWD
}
"' pg_dump --format=plain--file --create -U '"
$DB_USER
"' '"
$DB_NAME
"'"
>
${
DB_NAME
}
.sql
# pg_dump postgresql://username:password@127.0.0.1:5432/mydatabase
fi
case
$DB_ENGINE
in
"mysql"
|
"mariadb"
)
$SSHNOPASS
"mysqldump '"
$DB_NAME
"' -u '"
$DB_USER
"' -p'"
${
DB_PWD
}
"'"
>
${
DB_NAME
}
.sql
;;
"pgsql"
)
#- !! TO TEST !!
# $SSHNOPASS "PGPASSWORD='"${DB_PWD}"' pg_dump --format=plain--file --create -U '"$DB_USER"' '"$DB_NAME"'" > ${DB_NAME}.sql
$SSHNOPASS
"PGPASSWORD='"
${
DB_PWD
}
"' pg_dump -F p -U '"
$DB_USER
"' '"
$DB_NAME
"'"
>
${
DB_NAME
}
.sql
# pg_dump postgresql://username:password@127.0.0.1:5432/mydatabase
;;
esac
echo
"*** Database dump downloaded! ***"
}
Loading