Apache Friends Support Forum

I have been successfully using an implementation of LAMPP (XAMPP) on Ubuntu 8.04 server and it has been running just fine.

I have run into an issue with Mysql limiting exported (i.e.: into outfile "/opt/lampp/htdocs/foo") where the output is being limited to only 1000 rows/records.

According to my research this is a configurable option in the my.cnf file. As I am using the lampp supplied version of mysql, has anyone had experience with particular issue? I have located the /opt/lampp/etc/my.cnf configuration file and there is nothing that I can see that is limiting the output.

The google searches are rather sparse and inconclusive.

Any ideas/recommendations greatly appreciated.

Thanks -

I have run into an issue with Mysql limiting exported (i.e.: into outfile "/opt/lampp/htdocs/foo")

- You have an error message?
- You are using the MySQL command line client for this command?

No error message. The completion message stated 1000 rows.

And yes, I am using the Mysql CLI.

BTW - I DID try stating LIMIT 500000 and was able to extract over a quarter million rows. So, how can one eliminate this 1000 row limit default?

Thanks

The completion message stated 1000 rows.

The same SELECT, without "INTO OUTFILE" retrieves more then 1000 rows?

BTW:
A "SHOW WARNINGS;" can give you more infos about possible problems with your last statement.

Have you tried to create an export file using PHPMyAdmin?