Re: [D] Table guest_os_hypervisor (and/or guest_os) mixed up? [cloudstack]

["mwaag (via GitHub)" <gi...@apache.org>]

GitHub user mwaag added a comment to the discussion: Table guest_os_hypervisor (and/or guest_os) mixed up?

@weizhouapache 
With the intention of fixing the problems first, would it be possible to just overwrite both tables with a version of a freshly installed cloudstack 4.20.3.0 or is this a bad idea?

like
```shell
db-host-of-a-fresh-instance: mysqldump cloud guest_os guest_os_hypervisor > cloudstack420_fresh_guestostables.sql
old-db-host: mysql cloud < cloudstack420_fresh_guestostables.sql
``` 

In fact: I did it this way last year to fix our database (and things went fine until the upgrade to 4.20.3.0).




GitHub link: https://github.com/apache/cloudstack/discussions/13511#discussioncomment-17497576

----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org