1.1beta10 - sql patch failed

[rickardp]

Tried to apply the latest patch but got an error, and now I'm stuck in nomansland

[root@zabbix zabbix-1.1beta10]# cd upgrades/dbpatches/1.1beta9_to_1.1beta10/
[root@zabbix 1.1beta9_to_1.1beta10]# cd mysql/
[root@zabbix mysql]# cat patch.sql | mysql -Uroot zabbix
ERROR 1175 (HY000) at line 37: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

How do I fix or rollback this?

I'm using MySQL version 4.1.12

I tried to run mysql with '--force' option which left me in an even stranger state.

and

cat patch.sql | mysql --safe-updates=FALSE -f -Uroot zabbix

didn't really help the situation one bit

Now I really wish that I have done a backup before I tried to upgrade.