Thanks for the heads up, but it still doesnt like this line ns2# cd sql/mysql/ ns2# mysqladmin create dbmail ns2# mysql dbmail < create_tables_innoDB.mysql ERROR 1067 at line 6: Invalid default value for 'alias_idnr'
On Tue, 2003-06-10 at 21:23, [EMAIL PROTECTED] wrote: > 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 > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
