table backup with "where"

nbelfort posted 5 years ago in General
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
ansgar posted 5 years ago
You cannot do that with HeidiSQL. I guess mysqldump.exe has such an option.
jfalch posted 5 years ago
"How can I backup "partial" tables with a where condition?"
not directly possible with heidisql AFAIK.
-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
jfalch posted 5 years ago
@anse: yes, mysqldump v5.1+ has a --where option.

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