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