[SOLVED] Re: problem with altering a table

2006-06-21 Thread Alex
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]

Re: problem with altering a table

2006-06-21 Thread Gabriel PREDA
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 con

Re: problem with altering a table

2006-06-21 Thread Alex
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 ALTE

problem with altering a table

2006-06-20 Thread Alex
Hi, I'm using dbmail - a program that holds mails in a database, for example mysql. I'm in the process of migrating an old installation to the current one. dbmail does provide a migration script, but I've encountered a problem. It definitely is mysql specific and I haven't yet gotten a respon