# export data to file
mysqldump -uroot -ppassword hornet > hornet-dump.sql

# Drop database schema
mysqladmin -uroot -ppassword –f drop hornet

# create empty database schema
mysqladmin –uroot –ppassword create hornet

# push dump file into new database schema
mysql -uroot -ppassword hornet < hornet-dump.sql