mysql problem importing data

From: Date: Thu, 07 Aug 2003 18:55:01 +0000
Subject: mysql problem importing data
Groups: php.db 
Request: Send a blank email to php-db+get-29751@lists.php.net to get a copy of this message
Hi there, I have a data file with data seperated by semicolons. It is about 8MB big. Now I just want to import it into mysql. I tryed several things. First I took phpmyadmin, which resulted in a white page without error msg. Then I tryed it by hand with load data. This did not work as well. No I installed myodbc and tryed to export it from MS Access. This completly crashes my database server with this message: /usr/local/mysql/bin/safe_mysqld: line 1: 1067 Segmentation fault nice --5 nohup /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/home/m ysqladm/data --user=mysql --pid-file=/home/mysqladm/var/mysqld.pid --skip-lo cking -u mysqladm >>/home/mysqladm/data/SARATOGA.err 2>&1 030807 00:00:45 mysqld ended Has anybody an idea on how to import that data? Its nicely seperated by ; Thanx for any help, Merlin

« previous php.db (#29751) next »