Alex wrote:
I'm running mysql 5.0.22 on SLES9, using the mysql.com appropriate rpm.
I've tried other versions of mysql 5, including 5.0.6, 5.0.17, 5.0.18
and 5.0.21. The result is always the same. This leads me to believe,
that there are new requirements for mysql 5 and that's the reason
When creating the InnoDB table the InnoDB engine asigns to the FOREIGN
KEY you defined a symbol.
On my server it generated dbmail_messageblks_ibfk_1... and if in the
ALTER statement I entered:
DROP FOREIGN KEY dbmail_messageblks_ibfk_1
Then the ALTER table worked fine...
If you want to
Gabriel PREDA wrote:
Hope this helps !
Thanks a bunch, that was it. Problem solved.
I'll tell about it on the dbmail list as well.
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]