I upgraded my openser installation to 1.1 on debian sarge using the packages at 'deb http://www.openser.org/debian'. I then tried to upgrade my mysql tables using /usr/sbin/openser_mysql.sh reinstall. However, when doing the dump openser_mysql.sh calls mysqldump with the '--ignore-table=' option, which doesn't seem to be supported on the sarge version of mysql (4.0.24-10sarge2). Is there a way around this?
Jeff
Hi Jeff,
I was not aware that this option is not supported on older versions of mysqldump. The problem is that the old "version" table does not need to be copied in the new DB, so that's the reason why the table is ignored.
A fast work around will be to remove or rename the "version" table before running the re-install. Then you can take out the ignore option.
regards, bogdan
Jeff Williams wrote:
I upgraded my openser installation to 1.1 on debian sarge using the packages at 'deb http://www.openser.org/debian'. I then tried to upgrade my mysql tables using /usr/sbin/openser_mysql.sh reinstall. However, when doing the dump openser_mysql.sh calls mysqldump with the '--ignore-table=' option, which doesn't seem to be supported on the sarge version of mysql (4.0.24-10sarge2). Is there a way around this?
Jeff
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-
Bogdan-Andrei Iancu -
Jeff Williams