Hi. I higly recomend to use innodb tables instead of the MyISAM ones, because your email system will have problem when database grew up beyond 2 GB. I'm using Postfix 2.0.10, Mysql 4.0.12 in Solaris x86. No problem with database creation.
mysql -p**** dbmail < create_tables_innoDB.mysql Your Mysql must support Innodb and your need to enable it. To do so, edit your my.cnf file. For example, to enable autoexensible innodb tables with a initial size of 100 MB, you put following line below [mysqld] in my.cnf [mysqld] innodb_data_file_path=ibdata1:100M:autoextend Regards, Alejandro Marin > FreeBSD 5.1 & M<ySQL 4.10 > > mysql -p****** dbmail < create_tables.mysql > ERROR 1067 at line 6: Invalid default value for 'alias_idnr' > > ns2# mysqladmin -pSecured version > mysqladmin Ver 8.40 Distrib 4.1.0-alpha, for portbld-freebsd5.1 on i386 > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > and you are welcome to modify and redistribute it under the GPL license > > Server version 4.1.0-alpha > Protocol version 10 > Connection Localhost via UNIX socket > UNIX socket /tmp/mysql.sock > Uptime: 22 hours 16 min 29 sec > > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
