Auto loading a table

[gunmuse]

I have a table fsearch_temp I use it as a memory table to keep things light and fast but after a restart I want to repopulate some data automatically.  So I thought I just said load from TEST2 which would by a myisam table containing the hardbackup I need.  But obviously not the right way of saying this.  I must be reading the instructions wrong can someone clarify this for me?   CREATE TABLE `fsearch_temp` ( `fsearchId` bigint( 19 ) unsigned NOT NULL AUTO_INCREMENT , `fsearchHost` varchar( 100 ) NOT NULL default '', `fsearchSite` varchar( 255 ) NOT NULL default '', `fsearchDescription` varchar( 255 ) NOT NULL default '', `fsearchUrl1` varchar( 255 ) NOT NULL default '', `fsearchUrl2` varchar( 255 ) NOT NULL default '', `fsearchUrl3` varchar( 255 ) NOT NULL default '', `fsearchUrl4` varchar( 255 ) NOT NULL default '', `fsearchTime` int( 11 ) NOT NULL default '0', `fsearchIp` varchar( 22 ) NOT NULL default '', `fsearchKeyword` varchar( 100 ) NOT NULL default '', `fsearchBid` varchar( 11 ) NOT NULL default '0', `fsearchClicked` varchar( 6 ) NOT NULL default 'no', PRIMARY KEY ( `fsearchId` ) , KEY `fsearchIp` ( `fsearchIp` ) ) ENGINE = MEMORY LOAD FROM TEST2 DEFAULT CHARSET = utf8 AUTO_INCREMENT =0 Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183