RE: This just seems to slow

2011-01-03 Thread Jerry Schwartz
Folks, this is getting creepy. It seems like each of the variations you've given me works some times and not others. I haven't found the pattern yet. During the hours it took my initial data loads to finish, I rewrote the import process so that (I hope) I won't have to go through this again. Th

Re: tmpdir running out of space

2011-01-03 Thread joshua
> I'm new to MySQL, and I hope somebody can help me. > I have a 3.7G database and a 10G tmpdir. > Sometimes the tmpdir runs out of space, and I get the following message on > the logs: > [ERROR] /usr/libexec/mysqld: Incorrect key file for table > '/tmp/tmpdir/#sql_22f_33.MYI'; try to repair it > Se

tmpdir running out of space

2011-01-03 Thread Santiago Soares
Hello, everybody! I'm new to MySQL, and I hope somebody can help me. I have a 3.7G database and a 10G tmpdir. Sometimes the tmpdir runs out of space, and I get the following message on the logs: [ERROR] /usr/libexec/mysqld: Incorrect key file for table '/tmp/tmpdir/#sql_22f_33.MYI'; try to repair

RE: mysqlimport doesn't work for me

2011-01-03 Thread Jerry Schwartz
>-Original Message- >From: Carsten Pedersen [mailto:cars...@bitbybit.dk] >Sent: Monday, January 03, 2011 1:48 PM >To: Jerry Schwartz >Cc: 'mos'; mysql@lists.mysql.com >Subject: Re: mysqlimport doesn't work for me > >It's been a long time sine I used mysqlimport, but you might want to try: >

RE: This just seems to slow

2011-01-03 Thread mos
Jerry, Try this: mysqlimport -uusername -ppassword --verbose --debug-info --delete --columns=`dm_history_dm_id`,`DM_History_Customer_ID` --local --fields-terminated-by="," --fields-optionally-enclosed-by="\"" --lines-terminated-by="\r\n" --host=localhost yourdbname t_dmu_history.txt I

RE: This just seems to slow

2011-01-03 Thread Jerry Schwartz
>-Original Message- >From: Gavin Towey [mailto:gto...@ffn.com] >Sent: Monday, January 03, 2011 1:47 PM >To: Jerry Schwartz; 'mos'; mysql@lists.mysql.com >Subject: RE: This just seems to slow > >I much prefer LOAD DATA INFILE to mysqlimport. The issue looks like you have >a >file with two

Re: mysqlimport doesn't work for me

2011-01-03 Thread Carsten Pedersen
It's been a long time sine I used mysqlimport, but you might want to try: - using "--fields-terminated-by" rather than "--fields-terminated" - losing (or escaping) the backticks in --columns= - checking my.cnf to see if the client settings are the same for mysql> and mysqlimport - checking user

RE: This just seems to slow

2011-01-03 Thread Gavin Towey
I much prefer LOAD DATA INFILE to mysqlimport. The issue looks like you have a file with two columns, and a table with three. You will probably need to be more specific about which columns map to which fields in the file. Please report the error with any commands you run. Also, most importan

mysqlimport doesn't work for me

2011-01-03 Thread Jerry Schwartz
This works: localhost >TRUNCATE t_dmu_history; Query OK, 0 rows affected (0.41 sec) localhost >LOAD DATA LOCAL INFILE 't_dmu_history.txt' INTO TABLE t_dmu_history FIELDS TERMINATED BY "," (`dm_history_dm_id`,`dm_history_customer_id`); Query OK, 876211 rows affected (25.16 sec) Records: 876211

RE: This just seems to slow

2011-01-03 Thread Jerry Schwartz
Okay, I have a confession to make: I have never gotten Load Data Infile or mysqlimport to work. Here's my CSV file, named "t_dmu_history.txt": 13071,299519 13071,299520 13071,299521 13071,299522 13071,299524 13071,299526 13071,299527 ... Here's my mysqlimport command: mysqlimport -uaccess -pxx

Re: This just seems to slow

2011-01-03 Thread Shawn Green (MySQL)
On 1/3/2011 10:41, Jerry Schwartz wrote: -Original Message- From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Sunday, January 02, 2011 11:49 PM ... Also delete your INDEX / KEYs and add them at the very end instead. [JS] Wouldn't it take as long to build the indices? I guess it p

RE: This just seems to slow

2011-01-03 Thread Jerry Schwartz
>-Original Message- >From: Daevid Vincent [mailto:dae...@daevid.com] >Sent: Sunday, January 02, 2011 11:49 PM >To: mysql@lists.mysql.com >Cc: 'mos' >Subject: RE: This just seems to slow > >Another option would be to mangle your insert statement with some other >language like PHP, Python, Ru

RE: This just seems to slow

2011-01-03 Thread Jerry Schwartz
>-Original Message- >From: Wagner Bianchi [mailto:wagnerbianch...@gmail.com] >Sent: Monday, January 03, 2011 4:42 AM >To: Daevid Vincent >Cc: mysql@lists.mysql.com; mos >Subject: Re: This just seems to slow > >Multiple line insert is the better choice...it will be organized in >transaction

HNY-2011

2011-01-03 Thread Adarsh Sharma
Dear all, A very-very Happy New Year 2011 to all. May God Bless all of us to solve future problems. Thanks and Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

ANN: New Year's Sale at Upscene Productions, 25% discount!

2011-01-03 Thread Martijn Tonies
New Year's Sale at Upscene Productions, 25% discount! Dear reader, We wish you the best for 2011. We would like to point you to our New Year's Sale! Go to http://www.upscene.com and use coupon code "NY2011" when ordering. With regards, Martijn Tonies Upscene Productions www.upscene.com -

Re: This just seems to slow

2011-01-03 Thread Wagner Bianchi
Multiple line insert is the better choice...it will be organized in transaction blocks of many lines and it will speed up data insertion. [bian...@mysql.com]# mysqldump -u root -p --all-databases -e > file.dump -e: extended-inserts Best regards. -- Wagner Bianchi 2011/1/3 Daevid Vincent > Ano