delete all tables inside zabbix database, restore from bz2

Delete all tables, this will save all permissions to the database:

echo "zabbix"| xargs -I{} sh -c "mysql -uroot -p5sRj4GXspvDKsBXW -Nse 'show tables' {}| xargs -I[] mysql -uroot -p5sRj4GXspvDKsBXW -e 'SET FOREIGN_KEY_CHECKS=0; drop table []' {}"

Restore:

bzcat all.201809201023.bz2 |sudo mysql -uroot -p5sRj4GXspvDKsBXW zabbix