question Re: Backup MySQL tables schemas used in hive in Support Questions

Backup MySQL tables schemas used in hive

drgenious — Thu, 15 Jul 2021 11:34:13 GMT

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.

Re: Backup MySQL tables schemas used in hive

asish — Sun, 18 Jul 2021 15:37:43 GMT

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/