mysqlでデータがクラッシュしたら、
myisamchkのコマンドを使います。
mysql本家本元でmyisamchk
http://dev.mysql.com/doc/refman/4.1/ja/table-maintenance.html
mysqlのMyISAM型 の実際のファイルは３つ構成で、*.frmと*.MYDと*.MYになります。これが壊れるので、定期バックアップが必要。
この３つのファイルの説明は下記に。I
ftp://ftp.oss.eznetsols.org/mysql/doc/refman/5.1/ja/crash-recovery.html%3Fff=nopfpls
数G単位の大容量データはコマンドで戻すのは、難しいのでミラーするか、ファイル自体をバックアップすることをおススメします。
参照可能にしたままバックアップができる標準コマンド
mysqlhotcopy の説明。
http://dev.mysql.com/doc/refman/5.1/ja/mysqlhotcopy.html
| Cookie | 期間 | 説明 |
|---|---|---|
| cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
| cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
| cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
| cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
| cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
| viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |