Продюсер

Продюсер
Рейтинг
36
Регистрация
09.11.2010
Форум энергетического напитка. тИЦ 30 PR 1

Кто сколько предложит за сайт?

Форум энергетического напитка. тИЦ 30 PR 1

UPDATE

Старт - 4000 руб

Шаг - 500 руб

Проблема с резервным копированием.

Все разрешилось. Всем спасибо.

Проблема с резервным копированием.
MarcusTven:
Продюсер,
Сделайте: 
mysqlcheck -u root -p --analyze --auto-repair --optimize odenejka

Вывод сюда.

[root@92 ~]# mysqlcheck -uroot -p*** --analyze --auto-repair --optimize odenejka

Error: mysqlcheck doesn't support multiple contradicting commands.

[root@92 ~]#

---------- Добавлено 30.01.2013 в 20:20 ----------

izyalex:
1. Выключаем mysql-сервер, у меня так:

/etc/init.d/mysql stop

2. Делаем бэкап файлов с табличками, потому что в доках написано, что надо, потому что все может поломаться совсем. В моем случае - я тупо скопировал 3 файла из /var/lib/mysql/database/:

table.frm
table.MYD
table.MYI
Где "database" - название базы, где сдохла табличка, а "table" - название самой сдохшей таблички.

3. Смотрим, что сломалось, используя команду myisamchk:

myisamchk /var/lib/mysql/table.MYI

Предлагает починить.

4. Собственно, запускаем починку опцией -r:

myisamchk -r /var/lib/mysql/database/table.MYI

5. Запускаем сервер обратно:

/etc/init.d/mysql start

[root@92 ~]# myisamchk /var/lib/mysql/odenejka/wp_postmeta.MYI

Checking MyISAM file: /var/lib/mysql/odenejka/wp_postmeta.MYI

Data records: 120 Deleted blocks: 0

- check file-size

- check record delete-chain

- check key delete-chain

- check index reference

- check data record references index: 1

- check data record references index: 2

- check data record references index: 3

- check record links

[root@92 ~]#

---------- Добавлено 30.01.2013 в 21:22 ----------

ну или вот так еще:

[root@92 ~]# mysqlcheck -uroot -p**** --analyze odenejka odenejka.wp_commentmeta Table is already up to date
odenejka.wp_comments Table is already up to date
odenejka.wp_links Table is already up to date
odenejka.wp_options OK
odenejka.wp_postmeta Table is already up to date
odenejka.wp_posts Table is already up to date
odenejka.wp_term_relationships Table is already up to date
odenejka.wp_term_taxonomy Table is already up to date
odenejka.wp_terms Table is already up to date
odenejka.wp_usermeta Table is already up to date
odenejka.wp_users Table is already up to date
[root@92 ~]# mysqlcheck -uroot -p**** --auto-repair odenejka odenejka.wp_commentmeta OK
odenejka.wp_comments OK
odenejka.wp_links OK
odenejka.wp_options OK
odenejka.wp_postmeta OK
odenejka.wp_posts OK
odenejka.wp_term_relationships OK
odenejka.wp_term_taxonomy OK
odenejka.wp_terms OK
odenejka.wp_usermeta OK
odenejka.wp_users OK
[root@92 ~]# mysqlcheck -uroot -p**** --optimize odenejka odenejka.wp_commentmeta OK
odenejka.wp_comments OK
odenejka.wp_links OK
odenejka.wp_options OK
odenejka.wp_postmeta OK
odenejka.wp_posts OK
odenejka.wp_term_relationships OK
odenejka.wp_term_taxonomy OK
odenejka.wp_terms OK
odenejka.wp_usermeta OK
odenejka.wp_users OK
[root@92 ~]#
Проблема с резервным копированием.

Эта таблица не востанавливается. И ее бекап не делается.((

Проблема с резервным копированием.

По этой таблице пишет :

Warning: number of rows changed from 118 to 120

Проблема с резервным копированием.
MarcusTven:
Продюсер,
Какую команду вводите в консоли надеясь на лечение?

Да я в isp manager нажимаю лечить)

Поделитесь командой.

Проблема с резервным копированием.

в базе валятся ошибки:

130129 5:55:30 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 5:55:31 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 5:55:32 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 5:55:34 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 5:55:35 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 5:55:36 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 5:55:38 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 5:55:39 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 5:55:41 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 6:00:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 6:27:06 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 6:27:06 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 6:27:06 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 6:27:06 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 6:30:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 6:56:08 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 6:56:08 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 6:58:46 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 6:58:46 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 7:00:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 7:30:02 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 8:00:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 8:30:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 9:00:02 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 9:30:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 10:00:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 10:30:02 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 11:00:02 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 11:30:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 12:00:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 12:30:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 13:00:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 13:30:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 13:37:45 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 14:00:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 14:17:28 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 14:17:28 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 14:17:28 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 14:17:28 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 14:30:01 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 14:51:02 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
130129 14:51:02 [ERROR] /usr/libexec/mysqld: Table './odenejka/wp_postmeta' is marked as crashed and should be repaired
Проблема с резервным копированием.

Видимо, не удалось восстановить таблицу так как она была занята.

Может перед лечением отключить апачи?

Проблема с резервным копированием.

Естественно я пробывал лечить БД перед бекапом.

12345678 9
Всего: 86