OTRS database repair and backup

1. To back up the database command line:

   mysqldump-uroot-p***--database--skip-lock-tables--add-drop-table--flush-logs--default-character=utf8 OTRS > Otrs.sql

   Error occurs when:

   
   

   Errror:mysqldump:Couldn ' t execute ' show create TABLE ' article_attachment ': File './otrs/article_attachment. MYD ' not Found (errcode:13) (29)

Verified that this is a problem with database permissions

Workaround:

Chgrp-r mysql/var/lib/mysql && chown-r mysql/var/lib/mysql

(2) A second error

Mysqldump:error 1194:table ' Search_profile ' is marked as crashed and should being repaired when dumping Table ' Search_profi Le ' at row:46

Data Table index Error

Workaround:myisamchk-c-R /var/lib//mysql/tabname.myi

(3) A third error

Mysqldump:couldn ' t execute ' show create TABLE ' Xml_storage ': Incorrect file format ' Xml_storage ' (130)

Table-Type Error

Workaround:

Repair table Xml_storage use_frm;

After which the data instance can be backed up successfully

This article is from the "Life Need Wife" blog, so be sure to keep this source http://drsin.blog.51cto.com/10182098/1734997

OTRS database repair and backup