SEO

#1 (**permalink**) 02-28-2008, 10:32 AM

Hi all,
How do I export query results? I'm using phpmyadmin, which only lets
me export the whole database, or 1 page of the results. I get 10211
rows from this query, but everytime i LIMIT to 10000 rows the browser
doesn't finish loading the whole table.

#2 (**permalink**) 02-28-2008, 10:32 AM

On Jan 31, 10:09 am, Plantky <ngokang...@gmail.com> wrote:
> Hi all,
> How do I export query results? I'm using phpmyadmin, which only lets
> me export the whole database, or 1 page of the results. I get 10211
> rows from this query, but everytime i LIMIT to 10000 rows the browser
> doesn't finish loading the whole table.

Export to a file instead, that will be much faster and less likely to
fail.

#3 (**permalink**) 02-28-2008, 10:32 AM

On 31 Jan, 09:09, Plantky <ngokang...@gmail.com> wrote:
> Hi all,
> How do I export query results? I'm using phpmyadmin, which only lets
> me export the whole database, or 1 page of the results. I get 10211
> rows from this query, but everytime i LIMIT to 10000 rows the browser
> doesn't finish loading the whole table.

PMA allows you to export a table by itself, not just the whole
database or one page of results.

#4 (**permalink**) 02-28-2008, 10:32 AM

Plantky wrote:
> Hi all,
> How do I export query results? I'm using phpmyadmin, which only lets
> me export the whole database, or 1 page of the results. I get 10211
> rows from this query, but everytime i LIMIT to 10000 rows the browser
> doesn't finish loading the whole table.
>

What error message do you get? Is something timing out? Or are you
running out of memory on your script?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode