table backup with "where"
| User, date | Message |
|---|---|
|
Written by nbelfort
7 months 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
7 months ago 3972 posts since Fri, 07 Apr 06 |
You cannot do that with HeidiSQL. I guess mysqldump.exe has such an option. |
|
Written by jfalch
7 months ago 224 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 jfalch
7 months ago 224 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. |