why do you think I am getting this error The ‘partitioning’ feature is disabled; you need MySQL built with ‘–with-partition’ to have it working CREATE TABLE IF NOT EXISTS `202_clicks` ( `click_id` bigint(20) unsigned NOT NULL, `user_id` mediumint(8) unsigned NOT NULL, `aff_campaign_id` mediumint(8) unsigned NOT NULL, `landing_page_id` mediumint(8) unsigned NOT NULL, `ppc_account_id` mediumint(8) unsigned NOT NULL, `click_cpc` decimal(7,5) NOT NULL, `click_payout` decimal(6,2) NOT NULL, `click_lead` tinyint(1) NOT NULL default ’0′, `click_filtered` tinyint(1) NOT NULL default ’0′, `click_alp` tinyint(1) NOT NULL default ’0′, `click_time` int(10) unsigned NOT NULL, KEY `aff_campaign_id` (`aff_campaign_id`), KEY `ppc_account_id` (`ppc_account_id`), KEY `click_lead` (`click_lead`), KEY `click_filtered` (`click_filtered`), KEY `click_id` (`click_id`), KEY `overview_index` (`user_id`,`click_filtered`,`aff_campaign_id`,`ppc_account_id`), KEY `user_id` (`user_id`,`click_lead`), KEY `click_alp` (`click_alp`), KEY `landing_page_id` (`landing_page_id`), KEY `overview_index2` (`user_id`,`click_filtered`,`landing_page_id`,`aff_campaign_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (click_time) ( PARTITION p32 VALUES LESS THAN (1247641200) ENGINE = MyISAM, PARTITION p33 VALUES LESS THAN (1248850800) ENGINE = MyISAM, PARTITION p34 VALUES LESS THAN (1250060400) ENGINE = MyISAM, PARTITION p35 VALUES LESS THAN (1251270000) ENGINE = MyISAM, PARTITION p36 VALUES LESS THAN (1252479600) ENGINE = MyISAM, PARTITION p37 VALUES LESS THAN (1253689200) ENGINE = MyISAM, PARTITION p38 VALUES LESS THAN (1254898800) ENGINE = MyISAM, PARTITION p39 VALUES LESS THAN (1256108400) ENGINE = MyISAM, PARTITION p40 VALUES LESS THAN (1257318000) ENGINE = MyISAM, PARTITION p41 VALUES LESS THAN (1258527600) ENGINE = MyISAM, PARTITION p42 VALUES LESS THAN (1259737200) ENGINE = MyISAM, PARTITION p43 VALUES LESS THAN (1260946800) ENGINE = MyISAM, PARTITION p44 VALUES LESS THAN (1262156400) ENGINE = MyISAM, PARTITION p45 VALUES LESS THAN (1263366000) ENGINE = MyISAM, PARTITION p46 VALUES LESS THAN (1264575600) ENGINE = MyISAM, PARTITION p47 VALUES LESS THAN (1265785200) ENGINE = MyISAM, PARTITION p48 VALUES LESS THAN (1266994800) ENGINE = MyISAM, PARTITION p49 VALUES LESS THAN (1268204400) ENGINE = MyISAM, PARTITION p50 VALUES LESS THAN (1269414000) ENGINE = MyISAM, PARTITION p51 VALUES LESS THAN (1270623600) ENGINE = MyISAM, PARTITION p52 VALUES LESS THAN (1271833200) ENGINE = MyISAM, PARTITION p53 VALUES LESS THAN (1273042800) ENGINE = MyISAM, PARTITION p54 VALUES LESS THAN (1274252400) ENGINE = MyISAM, PARTITION p55 VALUES LESS THAN (1275462000) ENGINE = MyISAM, PARTITION p56 VALUES LESS THAN (1276671600) ENGINE = MyISAM, PARTITION p57 VALUES LESS THAN (1277881200) ENGINE = MyISAM, PARTITION p58 VALUES LESS THAN (1279090800) ENGINE = MyISAM, PARTITION p59 VALUES LESS THAN (1280300400) ENGINE = MyISAM, PARTITION p60 VALUES LESS THAN (1281510000) ENGINE = MyISAM, PARTITION p61 VALUES LESS THAN (1282719600) ENGINE = MyISAM, PARTITION p62 VALUES LESS THAN (1283929200) ENGINE = MyISAM, PARTITION p63 VALUES LESS THAN (1285138800) ENGINE = MyISAM, PARTITION p64 VALUES LESS THAN (1286348400) ENGINE = MyISAM, PARTITION p65 VALUES LESS THAN (1287558000) ENGINE = MyISAM, PARTITION p66 VALUES LESS THAN (1288767600) ENGINE = MyISAM, PARTITION p67 VALUES LESS THAN (1289977200) ENGINE = MyISAM, PARTITION p68 VALUES LESS THAN (1291186800) ENGINE = MyISAM, PARTITION p69 VALUES LESS THAN (1292396400) ENGINE = MyISAM, PARTITION p70 VALUES LESS THAN (1293606000) ENGINE = MyISAM, PARTITION p71 VALUES LESS THAN (1294815600) ENGINE = MyISAM, PARTITION p72 VALUES LESS THAN (1296025200) ENGINE = MyISAM, PARTITION p73 VALUES LESS THAN (1297234800) ENGINE = MyISAM, PARTITION p74 VALUES LESS THAN (1298444400) ENGINE = MyISAM, PARTITION p75 VALUES LESS THAN (1299654000) ENGINE = MyISAM, PARTITION p76 VALUES LESS THAN (1300863600) ENGINE = MyISAM, PARTITION p77 VALUES LESS THAN (1302073200) ENGINE = MyISAM, PARTITION p78 VALUES LESS THAN (1303282800) ENGINE = MyISAM, PARTITION p79 VALUES LESS THAN (1304492400) ENGINE = MyISAM, PARTITION p80 VALUES LESS THAN (1305702000) ENGINE = MyISAM, PARTITION p81 VALUES LESS THAN (1306911600) ENGINE = MyISAM, PARTITION p82 VALUES LESS THAN (1308121200) ENGINE = MyISAM, PARTITION p83 VALUES LESS THAN (1309330800) ENGINE = MyISAM, PARTITION p84 VALUES LESS THAN (1310540400) ENGINE = MyISAM, PARTITION p85 VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */;