blob: 5bc248a391f7485c5ab74b81a12c0a7699bc8517 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
#mysqldump -uroot trunk --extended-insert=FALSE --complete-insert=TRUE --quote-names=FALSE
DBNAME=trunk
echo "truncate table alerts"|mysql -uroot $DBNAME
echo "truncate table auditlog"|mysql -uroot $DBNAME
echo "truncate table events"|mysql -uroot $DBNAME
echo "truncate table history"|mysql -uroot $DBNAME
echo "truncate table history_uint"|mysql -uroot $DBNAME
echo "truncate table history_log"|mysql -uroot $DBNAME
echo "truncate table history_text"|mysql -uroot $DBNAME
echo "truncate table profiles"|mysql -uroot $DBNAME
echo "truncate table trends"|mysql -uroot $DBNAME
echo "truncate table dhosts"|mysql -uroot $DBNAME
echo "truncate table dservices"|mysql -uroot $DBNAME
mysqldump -uroot $DBNAME --quote-names=FALSE
|
