DB Cleanup Magento

clean.sql

TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;
TRUNCATE catalog_compare_item;
TRUNCATE core_url_rewrite;


update core_config_data set value = "http://newfit.com/" where config_id = 5;
update core_config_data set value = "http://newfit.com/" where config_id = 6;
update core_config_data set value = "/" where config_id = 34;
update core_config_data set value = "newfit.com" where config_id = 35;
update core_config_data set value = "http://newfit.com/login?view=login&tmpl=component" where config_id = 538;
update core_config_data set value = "http://newfit.com/" where config_id = 641;
update core_config_data set value = "http://newfit.com/" where config_id = 655;
update core_config_data set value = "http://newfit.com/" where config_id in (920,921,922);


UPDATE `replica`.`core_config_data` SET `value`='http://shop.fitn.in' WHERE `config_id`='5';
UPDATE `replica`.`core_config_data` SET `value`='http://shop.fitn.in' WHERE `config_id`='6';
UPDATE `replica`.`core_config_data` SET `value`='fitn.in' WHERE `config_id`='35';
UPDATE `replica`.`core_config_data` SET `value`='http://shop.fitn.in' WHERE `config_id`='641';
UPDATE `replica`.`core_config_data` SET `value`='http://shop.fitn.in' WHERE `config_id`='655';
UPDATE `replica`.`core_config_data` SET `value`='http://shop.fitn.in' WHERE `config_id`='920';
UPDATE `replica`.`core_config_data` SET `value`='http://shop.fitn.in' WHERE `config_id`='921';
UPDATE `replica`.`core_config_data` SET `value`='http://shop.fitn.in' WHERE `config_id`='922';