Skip to main content

Stephan Miller

Stephan Miller's Public Library

SEOmoz | SEO and Social Media Benchmarking

This post should help anyone who has to answer questions like "but what does 'mozRank 5' mean?" It carries SEO benchmark data with metrics for around half a dozen sites from ten different niches, followed by social media benchmarks to give an idea of the impact and influence of votes and people on three social media sites.

feedproxy.google.com/~r/seomoz/~3/BdL629XkU7s/seo-and-social-media-benchmarking?title=SEO and Social Media Benchmarking - Preview

diigo

16 Nov 09

Magento - Wiki - Maintenance Script

<?
$db['host'] = '';                    // Database hostname
$db['name'] = '';                    // Database name
$db['user'] = '';                    // Database username
$db['pass'] = '';                    // Database password
$db['pref'] = '';                    // Database tables' prefix
 
if($_GET['clean'] == 'log') clean_log_tables();
if($_GET['clean'] == 'var') clean_var_directory();
 
function clean_log_tables() {
    global $db;
   
    $tables = array(
        'dataflow_batch_export',
        'dataflow_batch_import',
        'log_url',
        'log_url_info',
        'log_visitor',
        'log_visitor_info',
        'report_event'
    );
   
    mysql_connect($db['host'], $db['user'], $db['pass']) or die(mysql_error());
    mysql_select_db($db['name']) or die(mysql_error());
   
    foreach($tables as $v => $k) {
        mysql_query('TRUNCATE `'.$db['pref'].$k.'`') or die(mysql_error());
    }
}
 
function clean_var_directory() {
    $dirs = array(
        'var/cache/',
        'var/log/',
        'var/report/',
        'var/session/',
        'var/tmp/',
        'downloader/pearlib/cache/*',
        'downloader/pearlib/download/*'
    );
   
    foreach($dirs as $v => $k) {
        exec('rm -rf '.$k);
    }
}
?>

www.magentocommerce.com/...maintenance_script - Preview

magento database cleanup

1 - 20 of 1638 Next › Last »
Showing 20 items per page

Diigo is about better ways to research, share and collaborate on information. Learn more »

Join Diigo