1) Shutdown your metastore instance.
2) Perform a backup of your MySQL metastore database:
% mysqldump --opt > metastore_backup.sql
3) Execute the Hive 0.6 and Hive 0.7 upgrade scripts:
% mysql --user= --password= \
< upgrade-0.6.0.mysql.sql
% mysql --user= --password= \
< upgrade-0.7.0.mysql.sql