[Donny Lairson] Quick bump I never got an answer
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
