Hi, I cant figure out how to export an entire table to .CSV
I have found the 'export database' but dont think this does CSV.
And I found the 'export grid rows' but I cant get this to export all rows. (I have 2 million rows).
How do I export a big table to CSV
Such huge datasets are problematic in the "Export grid rows" dialog. You could try a SELECT ... INTO OUTFILE, and grab the output file from the server afterwards.
Second time I heard from a user about huge CSV exports. I should find and fix the memory problem in the export dialog.
Second time I heard from a user about huge CSV exports. I should find and fix the memory problem in the export dialog.
Thanks anse, though just to be clear, I dont think I experienced a memory problem or other bug. I figured out later that what might of worked was to change the max number of rows to 2million in preferences and then click 'display all rows' and re-run. But I though it would be easier to use phpmyadmin, which is a pity as it would be handy to use HeidiSQL for everything.
Could there be a CSV export option in the 'export database' menu?
Could there be a CSV export option in the 'export database' menu?
Yes, changing the max rows should work theoretically, only the huge number will most probably cause memory errors or extreme CPU load, as the dialog is not optimized for such large datasets. So, my thought was to refactor the dialog to find and fixe these bottlenecks.
There is no "export database" menu - what do you mean?
There is no "export database" menu - what do you mean?
I need to export big csv files to other data media - not just Excel.
Right now I'm spending h-o-u-r-s editing out the quotes and other stuff from a 15 million record "sql" file output by Heidi, cos I don't know how else to create that size csv file.
Does HeidiSQL have any facility to do this?
Right now I'm spending h-o-u-r-s editing out the quotes and other stuff from a 15 million record "sql" file output by Heidi, cos I don't know how else to create that size csv file.
Does HeidiSQL have any facility to do this?
Well you can fire your query and use the grid export dialog on that result. But you will run out of memory in such a situation. Instead, you should use mysqldump on the command line. See here for detailed instructions: http://stackoverflow.com/questions/12040816/mysqldump-in-csv-format
Please login to leave a reply, or register at first.