Bug #1803 auto backup/restore HEAP table
Submitted: 11 Nov 2003 4:26 Modified: 28 Nov 2005 8:00
Reporter: xuefer tinys Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:Any (all)
Assigned to: CPU Architecture:Any

[11 Nov 2003 4:26] xuefer tinys 
Description:
i suggest: HEAP table which is small, can 'auto' Backup to file on disk in every N minutes
so it will be load when mysql is online->down->online

when ppl decided to use HEAP table, it usually means data stored in it is not important and is allowed to be lost.

ppl those using vhost may not able to use cron to run a backup/restore script
it would be nice mysqld itself data can be backup/restore heap tables automatically.

How to repeat:
1. mysqld online: backup HEAP table to table.MYD every N minutes
2. mysqld offline: all HEAP table in Memory is lost
3. mysqld online: load data from table.MYD into Memory
[28 Nov 2005 8:00] Valeriy Kravchuk 
Thank you for a feture request. HEAP (MEMORY) tables are designed so, that their data will be lost when servers stops. If you want to save their content each N minutes, why not to perform the appropriate actions (CREATE TABLE ... AS SELECT .. or INSERT INTO .. SELECT ...) in you client, start/stop script or from the cron job? I don't think that this feature has to be implemented by server.