Re: mysqlimport
| From: | Keith Spiller | 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