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
