Compare tables with : =show create table t1; =show create table t2; Check table type.
Or use dump command from shell: shell>mysqldump -pPassword --user=username db_name t1 > t1.sql mysql>rename table t1 to t2; shell>mysql -pPassword --user=username t1.sql > db_name Or try to set MIN_ROWS = 2,5 million. > 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 <mysql-unsubscribe- [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.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 --------------------------------------------------------------------- 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