SugarCRM Quick Repair and Rebuild From the Command Line

repair.php

#!/usr/bin/php
<?php

if(!defined('sugarEntry'))define('sugarEntry', true);
 
require_once('include/entryPoint.php');
require_once('modules/Administration/QuickRepairAndRebuild.php');
 
//Bug 27991 . Redirect to index.php if the request is not come from CLI.
$sapi_type = php_sapi_name();
if (substr($sapi_type, 0, 3) != 'cgi') {
    global $sugar_config;
  if(!empty($sugar_config['site_url'])){
		header("Location: ".$sugar_config['site_url'] . "/index.php");
	}else{
		sugar_die("Didn't find site url in your sugarcrm config file");
	}
}
//End of #27991
 
if(empty($current_language)) {
	$current_language = $sugar_config['default_language'];
}
 
$app_list_strings = return_app_list_strings_language($current_language);
$app_strings = return_application_language($current_language);
 
global $current_user;
$current_user = new User();
$current_user->getSystemUser();
 
$GLOBALS['log']->debug('--------------------------------------------> at repair.php <--------------------------------------------');
global $moduleList;
$repair = new RepairAndClear();
$repair->repairAndClearAll(array('clearAll'),$moduleList, true,false);
 
$exit_on_cleanup = true;
 
sugar_cleanup(false);
 
// some jobs have annoying habit of calling sugar_cleanup(), and it can be called only once
// but job results can be written to DB after job is finished, so we have to disconnect here again
// just in case we couldn't call cleanup
if(class_exists('DBManagerFactory')) {
	$db = DBManagerFactory::getInstance();
	$db->disconnect();
}
 
if($exit_on_cleanup) exit;

Copy this code to /usr/bin/repair.php and give the file execute permission. When in your SugarCRM directory you can just run repair.php

Gist Copied from https://gist.github.com/bickart/5468138 for my reference only. I do not own the codes.