I'm pretty new with iTop (and also with databases). I have a problem with the backup and restore of the database using MySQL dumper :( I added some documents for some CI's and the database became too large. So I made the documents very small and added the resized version of it. But the old document stayed in the history, so the data is still there saved in the table priv_changeop_setatt_data. I think it must be the history because if I don't save the table during a restore I get errors on the history of the document. Is there a way to delete the history in iTop (hope this question is not too stupid) or a nice way to clean the database :(
Thanks
Mel
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I think I have fixed it myself. I have set max_allowed_packet to 512M and I could restore the db without any errors.
This was the error message I got when I have configured MySQLDumper to continue in case of errors:
Error-Message : Restore failed: MySQL server has gone away
SQL : INSERT INTO documentfile (id,file_data,file_mimetype,file_filename) VALUES ('2','���� �Exi ... (snip)
But still I would like to know if there is a way to get rid of the history Data or if this would be automatically gone away after some time?
If I google for this I find a lot :) but only for browserhistories and not for itop
Cheers
Mel
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I think I got it myself with the help of another post I found:
I checked the table priv_change to get the id / change id. I checked the table priv_changeop for the changeid I got from the table priv_change. Then I deleted the entrys in the tables and the blobs in the table priv_changeop_setatt_date. If I open now the history of the document there is no error message any more and the big blob files are gone from the database. Also there is no history that I have changed the image ;) In the test system this is working fine. Hopefully it fixes also the productive iTop.
If I made anything wrong, please tell me. I'm new and I want to learn something.
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi all,
I'm pretty new with iTop (and also with databases). I have a problem with the backup and restore of the database using MySQL dumper :( I added some documents for some CI's and the database became too large. So I made the documents very small and added the resized version of it. But the old document stayed in the history, so the data is still there saved in the table priv_changeop_setatt_data. I think it must be the history because if I don't save the table during a restore I get errors on the history of the document. Is there a way to delete the history in iTop (hope this question is not too stupid) or a nice way to clean the database :(
Thanks
Mel
I think I have fixed it myself. I have set max_allowed_packet to 512M and I could restore the db without any errors.
This was the error message I got when I have configured MySQLDumper to continue in case of errors:
Error-Message : Restore failed: MySQL server has gone away
SQL : INSERT INTO
documentfile(id,file_data,file_mimetype,file_filename) VALUES ('2','���� �Exi ... (snip)But still I would like to know if there is a way to get rid of the history Data or if this would be automatically gone away after some time?
If I google for this I find a lot :) but only for browserhistories and not for itop
Cheers
Mel
Hi :)
I think I got it myself with the help of another post I found:
I checked the table priv_change to get the id / change id. I checked the table priv_changeop for the changeid I got from the table priv_change. Then I deleted the entrys in the tables and the blobs in the table priv_changeop_setatt_date. If I open now the history of the document there is no error message any more and the big blob files are gone from the database. Also there is no history that I have changed the image ;) In the test system this is working fine. Hopefully it fixes also the productive iTop.
If I made anything wrong, please tell me. I'm new and I want to learn something.
Thanks