How to TAKE backup of cmdb_ci table

Obito
Tera Expert

‎12-06-2023 04:41 AM - edited ‎12-06-2023 04:44 AM

Hi all

 

We are importing 5 million data into cmdb_ci table. & we want to take backup of cmdb_ci table before importing this amount data , so if the things goes wrong we can restore the data. How should we take it.

 

Thanks,

0 Helpfuls
  • 292 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎12-06-2023 05:31 AM

Hi @Obito 

 

Greetings!!

 

To take CMDB Back up

- Try to find out the CI  counts as per the classes

- Keep only data which is valid or don't add non operational data

- Club the classes ( For back up only) where count is less than 10K

- Make a schedule to back up 1 by 1 like computer , then server.

- Best way is Excel but XML is also a good way to do.

- Test this approach and take the lesson lerant.

- Export only in OOO hours to avoid the performance issue if any.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

kcornell002
Tera Contributor

‎01-31-2024 08:59 AM

How did you make out with this?

 

0 Helpfuls