Upgrade 1.8.10 to 2.0

[Tuxper]

Hi all.
I have zabbix server with mysql backend.
Size of mysql database is 22Gb.
I want to upgrade to 2.0, but when I run the mysql zabbix < patch.sql, it took over 1 hour.
I can't wait any more and interrupt the proccess and revert back to 1.8.10.
The history of all items is 90 days and dynamic is 365 days.
Now I have updated History to 30 days.
But size of MySQL database still is 22 Gb.
When the database will get small?

[GArmao]

at the next housekeeping (by default every hour) zabbix should clean the history,event and other tables according to the new retention.
Keep in mind that the actual size of your mysql database (datafiles on filesystem) will not shrink automatically, you'll need to optimize all the tables manually:

http://dev.mysql.com/doc/refman/5.1/...ize-table.html

optimizing a table, especially a big one like the history table, will take a lot of time and it will lock that table (aka no write to that table while optimizing)