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