export query results to database limited
I want to export a fairly big amount of rows from a SQL query results to another database but the amount is limited to 5.000 rows.
My procedure is: issue query, wait for results, then click on button "export to database", choose target database.
how to avoid such limit?
Please sign in to leave a comment.
It is not limited.
Perhaps you mean the page size?
No, I really mean the destination database only gets 5000 rows from 120000
Hm, it's not supposed to be like that. What if you export to CSV? Still 5000 rows?
Exporting to csv with no issue 1.200.000 rows
Can I ask for the screencast? It will make everything super-clear :)
Also, please, attach the SQL Log right after the import (Help | Show SQL Log...)