Re: mysqlimport

From: Date: Fri, 14 Sep 2001 08:55:48 +0000
Subject: Re: mysqlimport
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-12436@lists.php.net to get a copy of this message
Just incase anyone else is looking for the answer, the problem was solved thus: exec("/usr/local/mysql/bin/mysqlimport --replace --fields-terminated-by=\| - -user=testuser --password=testpassword testdb /home/testdomain/www/Admin/test_mysqltable.txt"); It just needed a path to the mysqlimport command... Keith ----- Original Message ----- From: "Keith Spiller" <larentium@gilanet.com> To: <php-db@lists.php.net> Sent: Thursday, September 13, 2001 6:51 PM Subject: [PHP-DB] mysqlimport Hello, I'm trying to use: passthru("mysqlimport --replace --fields-terminated-by=\| --user=testuser -- password=testpassword testdb /home/testdomain/www/Admin/test_mysqltable.txt", $output); The mysqlimport command works perfectly at the telnet command prompt, but never through Php. When I echo $output I get '126' or '127'. But the process does not work. I have also tried using system and exec commands. Any suggestions? Thanks, Keith

« previous php.db (#12436) next »