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

table backup with "where"

User, date Message
Written by nbelfort
2 years ago
Category: General
1 posts since Fri, 02 Nov 12
On table tools I can backup full tables...
How can I backup "partial" tables with a where condition?
I know I can export grid rows, but not with all the benefits of the table tools...
Thanks in advance
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
You cannot do that with HeidiSQL. I guess mysqldump.exe has such an option.
Written by jfalchMoney, Euro
2 years ago
380 posts since Sat, 17 Oct 09
"How can I backup "partial" tables with a where condition?"
not directly possible with heidisql AFAIK.
workaround:
-copy the "Create Code" from appropriate tab of table; modify
a) change name (eg suffix it with "tmp")
b) change engine clause to ENGINE=MEMORY.
put changed code into a query tab, execute.
-use insert ...select to copy data from existig table to new tmp table
-backup tmp table
Written by jfalchMoney, Euro
2 years ago
380 posts since Sat, 17 Oct 09
@anse: yes, mysqldump v5.1+ has a --where option.
 

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