Mysql into ourfile limiting to 1000 rows...

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Mysql into ourfile limiting to 1000 rows...

Postby BobMCT » 07. April 2009 21:58

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 - :?:
Registered Linux User #320395
BobMCT
 
Posts: 13
Joined: 05. August 2005 01:43
Location: CT USA

Re: Mysql into ourfile limiting to 1000 rows...

Postby Wiedmann » 07. April 2009 22:36

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?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Mysql into ourfile limiting to 1000 rows...

Postby BobMCT » 07. April 2009 22:46

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
Registered Linux User #320395
BobMCT
 
Posts: 13
Joined: 05. August 2005 01:43
Location: CT USA

Re: Mysql into ourfile limiting to 1000 rows...

Postby Wiedmann » 07. April 2009 23:15

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Mysql into ourfile limiting to 1000 rows...

Postby skuipers » 17. April 2009 16:58

Have you tried to create an export file using PHPMyAdmin?
skuipers
 
Posts: 99
Joined: 21. January 2005 16:27
Location: The Netherlands


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 8 guests