Export DB to One big File and Import just one table from it.

Export DB info One big fIle. Import just one table from it.

How?

You need to export only one table if you plan to only import that one later. You cannot create a backup with 10 tables and expect Heidi to import only one when you run that script - that's not possible. Instead, only check the relevant table when you're exporting.

Load the whole dump in a query tab, go to "Search/ Find Text" and locate the table, highlight the code you want to run, right click on it and select "Run selection".

Alternatively, open the dump in your favourite text editor and copy the SQL code into HeidiSQL.

Or load the dump into a test database and use the export feature to copy that table (and only that table) to wherever you need it.

> Alternatively, open the dump in your favourite text editor and copy the SQL code into HeidiSQL.

And I do it, but it`s not... conveniently (may be not right word, sorry)

Of course that's just a (non conveniant) workaround if you don't have the exact dump you need, but that can help a lot if you are not able to recreate the dump a second time for some reason.

However, the normal way is to create a SQL export of the items you want to import later.