rollback to backup mysql db command line

create database global2;
use global2;

grant all privileges on global2.* to 'global'@'localhost' identified by 'pw';
FLUSH PRIVILEGES;

zcat dbbkup.sql.gz | mysql -u root -p7fe423zaf4518cb65 global2;