How to export to csv with data a temporary table from a view

[expired user #9449]'s profile image [expired user #9449] posted 8 years ago in Import/Export Permalink
I need to export to csv the data and structure from a view. Can anyone help me figure this out. I should add that i know NOTHING about HeidiSQL, or SQL for that matter. I am a FileMaker developer and have been asked to duplicate a HeidiSQL database in FileMaker.
[expired user #8927]'s profile image [expired user #8927] posted 8 years ago Permalink
Apart from the fact that heidiSQL is not a database but a management frontend for various databases ...
You can select the view in the tree, click on "Data" in the right window and continue to Tools - export grid rows.
[expired user #9449]'s profile image [expired user #9449] posted 8 years ago Permalink
Wolfgang, Thank you for your reply. That allowed me to export 1000 rows. Any idea of a way to export all the rows? There are about 800,000
[expired user #8927]'s profile image [expired user #8927] posted 8 years ago Permalink
Yes. Copy the command from the bottom (SELECT * FROM `xxx`.`yyy` LIMIT 1000, 99000;) without the LIMIT clause, open a query tab, paste, F9. Then export. Hope your heidi does not crash. Otherwise you have got try more tricks.

Advice: You are trying to export a view. Would it not be better to take the original table(s) and rebuild the view in your own database?
[expired user #8927]'s profile image [expired user #8927] posted 8 years ago Permalink
wrwaugh, I read that FileMaker can connect to SQL databases. Figure out how Heidi connects to your database and try the same with FileMaker. Thus you might be able to extract your data directly. Or ask someone to do the extraction word for you, it should not be a big deal. Good luck, Wolfgang

Please login to leave a reply, or register at first.