Skip to main content
drgenious
drgenious
Silver ⭐️⭐️⭐️
July 15, 2021
Solved

Backup MySQL tables schemas used in hive

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.

asish
asishAnswer
Gold ⭐️⭐️⭐️
July 18, 2021

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 in thread

1 reply

asish
Gold ⭐️⭐️⭐️
asishAnswer
Gold ⭐️⭐️⭐️
July 18, 2021

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/ 

Translate
Terms & ConditionsAccessibility statement