Export large table

[expired user #5085]'s profile image [expired user #5085] posted 14 years ago in Import/Export Permalink
Hi, I cant figure out how to export an entire table. The options under the 'export' menu are 'export database', 'export selected' and 'export grid' (which exports the rows displayed). How do I export the entire table without first displaying all the table rows (as the table is quite big making displaying all rows an issue).
Thanks.
ansgar's profile image ansgar posted 14 years ago Permalink
You want "Export database", and then select the table before clicking the "Export" button.
jfalch's profile image jfalch posted 14 years ago Permalink
click on the table name in the database tree on heidi.main left side, then select "export database" from the export menu.
In the "table tools" dialog, click on the '+' before your database name, so that its tables are displayed; be sure that there is a check mark only on the database name and on the single table that you wish to export.
select "sql export" tab on the right, optionally select table and output options; select filename, and click on the "export" button.
(if there is a checkmark before the database name, but not before any table name, all tables will be exported.)
[expired user #5085]'s profile image [expired user #5085] posted 14 years ago Permalink
Thanks. I should have tried that menu option!

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