Support Questions
Find answers, ask questions, and share your expertise

Backup MySQL tables schemas used in hive

Explorer

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Expert Contributor

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/ 

View solution in original post

1 REPLY 1

Expert Contributor

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/ 

View solution in original post