Use BIGINT use altertable ...that will take a week Russell Griechen ----- Original Message ----- From: "Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 2:35 AM Subject: Strange BUG? with a working table
> Dear Ladies and Sirs, > > I have a problem to create a tables duplicate with: > > CREATE TABLE new_1 SELECT * FROM output_1; > > The table output_1 has this structure: > Field Type Null Key > af_1 int(11) YES MUL > af_3 varchar(255) YES > af_2 varchar(255) YES > af_23 varchar(255) YES > af_10 varchar(255) YES > af_11 varchar(255) YES > af_10001 varchar(255) YES > af_16 varchar(255) YES > af_9 varchar(255) YES > af_8 varchar(255) YES > af_30 varchar(255) YES > af_24 varchar(255) YES > af_52 varchar(255) YES > af_300 varchar(255) YES > af_53 varchar(255) YES > af_54 varchar(255) YES > af_18 varchar(255) YES > af_5 varchar(255) YES > af_25 varchar(255) YES > af_26 varchar(255) YES > af_27 varchar(255) YES > af_28 varchar(255) YES > af_55 varchar(255) YES > af_56 varchar(255) YES > af_57 varchar(255) YES > af_58 varchar(255) YES > dub_flag int(11) YES MUL > dub_kopf int(11) YES > dub_purge int(11) YES > > > Type = myisam > MySQL = 3.23-41-log > OS = SUSE 7.3 Kernel 2.4.10 > FS = Reiser > > This table has about 2,5 million rows and it's file-size 530543 K. > When i tried the above statement i got error 27 when the new table > reached a size of more then 2000000 K ! > I exported the file to csv and everything seemed fine. > I imported again into a new table via LOAD DATA INFILE ... and the same error occured. > > Is there anyone that has a clue, why this table is changing size with this. > Could it be that there is a 'forbidden' character inside the data ? > > I now try to manage with dump-file but I'd like to know how I can fix the problem itself, because > if I join this table with another, the same strange behaviour occurs. > CHECK TABLE (extended) said the output_1-Table is OK. > > please help > > Klaus > > > > Topaktuelle Consumer-Adressen anmieten www.consumeradressen.de > > > Diese Mail ist von: > Deutsche Post Direkt GmbH > Beleglese Center Mannheim > > Klaus Franz > Manager Abgleichsysteme > > Willy-Brandt-Platz 13 Tel. 06 21.129 56 436 > 68161 Mannheim > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
