Okay guys, Ive backed out of MySQL 4.1 to MySQL 4.0 all works fine now, so heads up avoid 4.12 until the database/scehama works for it
On Wed, 2003-06-11 at 03:34, Kerberus wrote: > Nope same error... Arrrggghhghhhhh > > On Tue, 2003-06-10 at 22:32, Aaron Stone wrote: > > Try changing the line so that the 0 is not '0'. Perhaps the lastest MySQL > > is picky about seeing numbers inside of quotes? > > > > Aaron > > > > > > On 11 Jun 2003, Kerberus wrote: > > > > > 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 > > > > > > _______________________________________________ > > > Dbmail mailing list > > > [email protected] > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > _______________________________________________ > > Dbmail mailing list > > [email protected] > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
