Sean, Monday, February 11, 2002, 10:01:55 PM, you wrote:
SH> I'm currently trying to move a database (~1.6GB) from a Linux system to a SH> Sun (Solaris 8). The Linux machine is running: SH> mysqld Ver 3.23.35 for pc-linux-gnu on i686 SH> The Sun is running: SH> mysqld Ver 3.23.47 for sun-solaris2.8 on sparc SH> I did a dump on the Linux box like this: SH> mysqldump -p --quick dbname | gzip > /output/file/path SH> Then I copied the file to the Sun and did: SH> gzcat outputfile.gz | mysql -p dbname SH> After a few minutes, I get the error: SH> ERROR 1171 at line 23984: All parts of a PRIMARY KEY must be NOT NULL; If SH> you need NULL in a key, use UNIQUE instead SH> Line 23984, etc. is: SH> CREATE TABLE mesg_bodies ( SH> mesgnum int(11) default NULL, SH> body longtext, SH> PRIMARY KEY (mesgnum) SH> ) TYPE=MyISAM PACK_KEYS=1; SH> I'm not sure what's happening here. Is there an error in mysqldump that SH> makes it generate invalid SQL? Is there an error in the MySQL version on my SH> Linux machine that allowed me to inadvertently create an illegal table (or SH> insert illegal data)? Is there an error in the MySQL version on my Sun that SH> makes it puke on something that should be legal? SH> It seems like tables that work fine on the Linux machine should be ok on the SH> Sun, but what do I know? SH> Anyone have ideas about what the problem is here and the best way to work SH> around it? It's not a mysqldump error. Primary key must be defined as NOT NULL. Look in the manual: http://www.mysql.com/doc/C/R/CREATE_TABLE.html SH> Thanks. SH> sean -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php