mysql problem importing data
| From: | Merlin | 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