Hi Chiu,
>It seems that you have reached the 2G file limit with many Linux system. I
>am not familiar with SuSe. As I know, you may try to use raid option. You
>may refer to MySQL doc. on 'create' for details.
Yes I know, that I can just manage files to 2 GB.
The question was, why is the new tables, that should just be the copy of
output_1, more than 3 times bigger.
I didn't add any data, neither did I change structure.
>may refer to MySQL doc. on 'create' for details.
I tried without CEATE ... SELECT (via LOAD DATA INFILE) and
it didn't work either.
Did I miss something in the docs ?
thanks and greetings
Klaus
>KH
>> 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
---------------------------------------------------------------------
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
