Here is more information:
from the log file:
120207 09:54:53 mysqld started
120207 9:54:54 InnoDB: Started; log sequence number 0 167636
120207 9:54:54 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
120208 11:08:31 InnoDB: Error: in ALTER TABLE `dbmail/dbmail_acl`
InnoDB: has or is referenced in foreign key constraints
InnoDB: which are not compatible with the new table definition.
120208 11:08:31 InnoDB: Error: table `dbmail/dbmail_acl` does not exist
in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
I have a Linux Fedora image running on VMware and the mysql version is
mysql-5.0.45-6.fc8.i386.
r...@smg.dirce2.lab:/var/log[160] df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 9.7G 3.8G 5.4G 42% /
/dev/mapper/VolGroup00-LogVol00
66G 461M 62G 1% /var
/dev/sda1 190M 26M 155M 15% /boot
tmpfs 1014M 0 1014M 0% /dev/shm
In google people say that this error message has nothing to do with disk
space, but it has to do with foreign key constraints. I am trying to
figure out why the command
SET FOREIGN_KEY_CHECKS=0;
at the beginning of the 2_2-3_0.mysql script does not prevent the ALTER
commands from complaining about the constraints.
mysql> show tables;
+---------------------------+
| Tables_in_dbmail |
+---------------------------+
| dbmail_acl |
| dbmail_aliases |
| dbmail_auto_notifications |
| dbmail_auto_replies |
| dbmail_envelope |
| dbmail_headername |
| dbmail_headervalue |
| dbmail_mailboxes |
| dbmail_messageblks |
| dbmail_messages |
| dbmail_mimeparts |
| dbmail_pbsp |
| dbmail_physmessage |
| dbmail_referencesfield |
| dbmail_replycache |
| dbmail_sievescripts |
| dbmail_subscription |
| dbmail_usermap |
| dbmail_users |
| sessions |
+---------------------------+
20 rows in set (0.01 sec)
Also, the script 2_2-3_0.mysql didn't have the 'use dbmail;' command, so I
added it at the beginning.
Thanks,
Dirce
>
>
> Am 08.02.2012 19:46, schrieb drsyst...@globalcerts.net:
>> Hi,
>>
>> I am running the script
>>
>> /var/lib/mysql/dbmail[157] mysql < 2_2-3_0.mysql
>>
>> on an old host (test host) that I want to migrate.
>>
>> I get the error:
>>
>> ERROR 1025 (HY000) at line 68: Error on rename of
>> './dbmail/#sql-9dd_357e'
>> to './dbmail/dbmail_users' (errno: 150)
>>
>> I have been fixing it one db at a time by doing:
>> mysql>show create table dbmail_...
>> and then
>> mysql>alter table dbmail_sievescripts drop foreign key
>> dbmail_sievescripts_ibfk_1; (for example)
>
> * what mysql version
> * what OS
> * what yasys the mysqld errorlog
> * how much free space on disk
>
> the error message alone is pointless because
> this is only a standard message of the mysql-client
>
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
