mysql_info() or similar

Anon

I am having a hard time with something that should be very trivial:

To retrieve the output from "LOAD DATA INFILE" (so that I can see if there were warnings / errors, etc. in the import)?

I could use mysql_info(), but it appears to be available in "php 4 cvs only." I need something that works on a stable release of php. I am running php 4.2.2.

Any help on this would be greatly appreciated!

Thanks,

Lars

bitbit

You can use mysql_error() to find if any error ocurred. Just put:

echo mysql_error();

after your query.

Anon

Thanks for your reply.

No, mysql_error() only reports errors executing the query (like syntactical errors, etc.) - it does not report problems with importing the contents. What I need is to be able to see if there were records that did not get imported properly. Example:

mysql> LOAD DATA LOCAL INFILE '/tmp/mysql_db.txt' REPLACE INTO TABLE items;
Query OK, 27276 rows affected (0.63 sec)
Records: 13638 Deleted: 13638 Skipped: 0 Warnings: 39

How can I retrieve the above output (or at least the warnings part) when running the query from PHP?

Thanks,

Lars

Anon

Ok, since there appears to be no way to run mysql_info directly from php (except for in the cvs version), I have made the following (ugly) work-around:

A simple perl-script that performs the "LOAD DATA INFILE" followed by printing the output of mysql_info to stdout. From php I simply execute this perl script with the standard back-ticks syntax so that I can capture its output into a variable.

This works, but if anyone has a better way to do this, please let me know.

Thanks,

Lars