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
table backup with "where"
"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
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
Please login to leave a reply, or register at first.