Hi Janos,
i’m trying to gat a working backup / restore script for my piler installations.
But my efforts are more or less without a success …
Perhaps you can give me a slight hint?
My backup script looks like this:
- - - - - - -
systemctl stop rc.piler.service
systemctl stop rc.searchd.service
tar -cpzf SOMEVZ/piler.tar.gz -C /usr/local/etc/piler .
tar -cpzf SOMEVZ//pilerstore.tar.gz -C /var/piler/store/00 .
tar -cpzf SOMEVZ/sphinx.tar.gz /var/piler/sphinx/main[1-4]*
mysqldump --single-transaction -h localhost -piler -p'mysecretpw' piler >
SOMEVZ/pilerdb.sql
systemctl start rc.piler.service
systemctl start rc.searchd.service
- - - - - - -
My restore script looks like this:
- - - - - - -
systemctl stop rc.piler.service
systemctl stop rc.searchd.service
rm -r /usr/local/etc/piler
rm -r /var/piler/store/00
rm /var/piler/sphinx/main[1-4]*
mkdir -p /usr/local/etc/piler
mkdir -p /var/piler/store/00
tar -xpzf SOMEVZ/piler.tar.gz -C /usr/local/etc/piler
tar -xpzf SOMEVZ//pilerstore.tar.gz -C /var/piler/store/00
tar -xpzf SOMEVZ/sphinx.tar.gz -C /
mysql -h localhost -upiler -p'mysecretpw' piler < SOMEVZ/pilerdb.sql
systemctl start rc.piler.service
systemctl start rc.searchd.service
- - - - - - -
All imported mails (figures) are show correctly inside the admin interface.
Searching for mail in the auditor interface shows no emails at all.
I guess this is a problem with sphinx database but i cant figure out …
Can you give me a little help on this please?
HW