Re: Upgrade from 4.0.26 to 5.0.67

2008-08-21 Thread Sebastian Mendel
Nanu Kalmanovitz schrieb: Hi! I wish to upgrade the MySQL on a web server (Novell 6.5 sp6 - Apache 2, MySQL ver. 4.0.26, PHP 5.2.3) to 4.1.2 or 5.0.67. Is there any possibility to upgrade directly from MySQL 4.0.26 to 5.0.67, without upgrading first to the intermediate versions? yes, but don

Upgrade from 4.0.26 to 5.0.67

2008-08-21 Thread Nanu Kalmanovitz
Hi! I wish to upgrade the MySQL on a web server (Novell 6.5 sp6 - Apache 2, MySQL ver. 4.0.26, PHP 5.2.3) to 4.1.2 or 5.0.67. Is there any possibility to upgrade directly from MySQL 4.0.26 to 5.0.67, without upgrading first to the intermediate versions? TIA Nanu -- MySQL General Mailing L

Re: Zip Codes with Leading Zeros

2008-08-21 Thread Keith Spiller
Thanks for all your suggestions Tom. The mixed 5 digit zip code and 10 digit zip+4 code data set are in a varchar(20) field. I don't recall if the data was identical in both the CSV and Excel files, but I do remember I had the same problem. It's been many months since I imported the original

Re: Zip Codes with Leading Zeros

2008-08-21 Thread Keith Spiller
Hi Johnny, Yeah. Sadly I missed the fact that the zip codes were hacked in our original Works to MySQL conversion until long after I had imported the data into our current MySQL table. Now we have to fix the numbers in our MySQL table and guarantee that we can export them out to Excel for the

RE: Zip Codes with Leading Zeros

2008-08-21 Thread Kralidis,Tom [Burlington]
Keith (I'm not very familiar with phpMyAdmin): what is the underlying datatype of your zip code field? On the command line, if I use: mysql> select * into outfile '/tmp/file.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' from tmp; (note that the default outp

Zip Codes with Leading Zeros

2008-08-21 Thread Keith Spiller
Hi, RE: Zip Codes with Leading Zeros We need to export a MySQL table with a zip code field to Excel. We currently use PhpMyAdmin to export to CSV or Excel files. We have had problems with zip codes with leading zeros. The leading zeros are removed so that we are left with incomplete codes.

Re: My Tables are "in use"

2008-08-21 Thread Moon's Father
This is weird issue that I have never met.I think you should show us your table's definition phrase and use flush tables to shut down all the open tables. On 8/21/08, Abdul Gomaa <[EMAIL PROTECTED]> wrote: > > Hey everyone! > > I really hope this is the right place to post this problem. I have hav

Re: mysqlimport/load data infile is using a temp file - why?

2008-08-21 Thread Moon's Father
You should increase parameter named max_bulk_insert_buffer_size and max_allowed_packet. On 8/21/08, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > Mysql use tmpdir, > when ever there is any index creation. > > regards > anandkl > > > On 8/21/08, jthorpe <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > >

Re: mysqlimport/load data infile is using a temp file - why?

2008-08-21 Thread Ananda Kumar
Mysql use tmpdir, when ever there is any index creation. regards anandkl On 8/21/08, jthorpe <[EMAIL PROTECTED]> wrote: > > Hi, > > I've been trying to import a 10G dump file using mysqlimport > and it is eventually failing because it runs out of tmpdir > space -- I get Errcode: 28. > > I was su

mysqlimport/load data infile is using a temp file - why?

2008-08-21 Thread jthorpe
Hi, I've been trying to import a 10G dump file using mysqlimport and it is eventually failing because it runs out of tmpdir space -- I get Errcode: 28. I was surprised that it was using a temp file at all. I've looked in the documentation and other sources but have not been able to find anything

My Tables are "in use"

2008-08-21 Thread Abdul Gomaa
Hey everyone! I really hope this is the right place to post this problem. I have have been struggling with this for over 3 months now. Have a look at the following screenshot: http://img395.imageshack.us/img395/8792/63815426ma1.jpg It just happened one day without me doing anything. And if I tr

Re: quick question on innodb_log_file_size

2008-08-21 Thread Mark Leith
Jenny Chen wrote: Hi, According to the reference manual, it was said that the combined lnnodb log file size is less than 4G on 32-bit system. But I'm running on my 64-bit solaris, I still got the error complaining the innodb log file >4G for my 64-bit MySQL. So I'm wondering is this 4G limit app