distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

User, date Message
Written by Allineer
4 years ago
Category: Feature discussion
47 posts since Thu, 01 Jul 10
Export DB info One big fIle. Import just one table from it.

How?
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
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.
Written by kalvaro
4 years ago
562 posts since Thu, 29 Nov 07
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.
Written by Allineer
4 years ago
47 posts since Thu, 01 Jul 10
> 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)
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
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.
 

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