Hello.
>) ENGINE = MEMORY LOAD FROM TEST2 DEFAULT CHARSET = utf8 AUTO_INCREMENT =0 You should use select statement, not LOAD. For example: CREATE TABLE ..... SELECT * FROM TEST2; And table options like DEFAULT CHARSET you should put before select statement. See: http://dev.mysql.com/doc/mysql/en/create-table.html [snip] 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 [snip] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
