mysql 145 Table is marked as crashed and should be repaired

Got error: 145: Table {sometable} is marked as crashed and should be repaired

I got the this error when trying to do a sqldump of my database.  To fix this error use the utility mysqlcheck from the command line.

This statment shows that the table is marked as crashed:

# mysqlcheck -uuser -ppass database table
warning  : Table is marked as crashed
status   : OK

This statement will repair the table:

# mysqlcheck -uroot -pvisitor --auto-repair database table
database.table                              OK


Monitoring Strategy and Architecture

In the attached child pages is information about IT Monitoring at Nu Skin.  This includes both the current state of monitoring, some research on best practices and a strategy for where we should take monitoring.  We want to move to more of a model where we manage to service levels not just responding to outage events.


PhpGedView Overview

Web3us LLC  provides hosting for your PhpGedView site for $2.41 a month (U.S. funds). That price includes a database of up to 3,000 individuals and 30 MB of data. Larger databases are available for increased fees.

PhpGedView is a genealogy program that allows you to view and edit genealogy data that is stored on your personal web site.


Solr for two sites running Drupal 6 Search on Tomcat 6 / CentOS 6

Note this tutorial sets up two seperate solr applications in tomcat, not multi core in one java application.

ApacheSolr for Drupal 6 improves on the out-of-the-box search experience for Drupal users. The easiest way to get Solr running on your Drupal web site is to use the hosted service provided by Acquia; it is way easier than running your own Solr. You simply point your queries to their Solr server and you’re done.


Upgrading Drupal 6 (D6) to drupal 7 (D7)

Upgrade Steps, Common Problems and Solutions

  1. Backup your existing site and database.
  2. Log in as user ID 1 (the site maintenance user).
    This is the user name that you created during the installation process for your site.
  3. Put your site in maintenance mode
    Go to the site maintenance page (Administer > Site configuration > Site maintenance or Select "Off-line" and save the configuration. If you have defined a custom maintenance theme in your settings.php file, comment it out before proceeding.
  4. Change all themes to Garland

Drupal Sites

Here is a list of Government and other large sites using Drupal, with links and screenshots for each site.  These are great examples of the flexibility and power of Drupal as a Content Management System (CMS).


Subscribe to Front page feed