Can't untar mysql on Solaris 8

2002-01-30 Thread Eurico de Sousa
Hi. I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for Sparc-Solaris 8 and all of them complain of a checksum error on the tar-extract. Here's the output of tar xvf of the gunzip'd-tar file: x mysql-3.23.46-sun-solaris2.8-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.

Batch load of data

2002-01-30 Thread Eurico de Sousa
Hi. I have a question regarding loading data from text files into tables using the LOAD DATA statement. I tried this under Win98 without success. Basically, I have a file called create.tbl which has CREATE TABLE statements. The last statements in this file are of the form: LOAD DATA INFILE "fi

Re: Can't untar mysql on Solaris 8

2002-01-30 Thread Eurico de Sousa
Appreciate those of you referring me to GNU tar - it did untar mysql properly whereas SUN's tar couldn't. Eurico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Batch load of data problems

2002-01-30 Thread Eurico de Sousa
Hi. Resubmitting a post... Basically, my question is if you have defined an INT NOT NULL AUTO_INCREMENT id field in a table, and you want to load a data file into the table using the LOAD DATA INFILE command, must you also put the ids in the data file? Thanks. Eurico *