Export large table

User, date	Message
Written by spiderplant0 3 years ago Category: Import/Export 9 posts since Fri, 06 Aug 10	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.
Written by ansgar 3 years ago 3957 posts since Fri, 07 Apr 06	You want "Export database", and then select the table before clicking the "Export" button.
Written by jfalch 3 years ago 223 posts since Sat, 17 Oct 09	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.)
Written by spiderplant0 3 years ago 9 posts since Fri, 06 Aug 10	Thanks. I should have tried that menu option!
	Please login to leave a reply, or register at first. Username: Password: Remember me