Backup MySQL tables schemas used in hive

[#1]

I used to have some tables in HIVE but after an incident HIVE went down and some new tables erased and old tables went back to a previous schema state.

What I want, is to ask if it is there any option to backup tables' schemas into MySQL which stores HIVE metastore in order to retrieve them if there occurred any incident again.

[#2 · Accepted solution]

All the hive related tables are stored under  "hive" database in mysql.

You can take mysql dump for a database hive and can prevent this from happening in the future.

You can use command like:

   mysqldump -u root -p hive

Reference: https://www.sqlshack.com/how-to-backup-and-restore-mysql-databases-using-the-mysqldump-command/