Ошибка переноса учетной записи cpanel: ОШИБКА: Не удалось сбросить одну или несколько баз данных

Получение этой ошибки при переносе нескольких учетных записей с помощью утилиты передачи whm:

ОШИБКА: не удалось создать дамп одной или нескольких баз данных.

Мне сказал об этом специалист по cpanel

Here is the specific error I'm seeing on some of the accounts:

warn [pkgacct] eli_test: mysqldump: Got error: 1034: Incorrect key file for table 'bak_components'; try to repair it when using LOCK TABLES

You may need to try to repair these tables as suggested in the error. After some further research I see you're using myisam, so you may want to use the myisam check and repair as well:

http://www.thegeekstuff.com/2008/09/how-to-repair-corrupted-mysql-tables-using-myisamchk/

Я уже запускал это:

mysqlcheck --all-databases -r
mysqlcheck --all-databases -a
mysqlcheck --all-databases -o

Кроме того, я даже повторно попытался передать с остановленным mysql, но получил следующее:

Determining mysql dbs.../usr/bin/mysqladmin: connect to server at 'localhost' failed

Я попытался восстановить mysiam:

root@server [/var/lib/mysql]# myisamchk --silent --force --fast --update-state /var/lib/mysql/e*/*.MYI
myisamchk: MyISAM file /var/lib/mysql/edisecur_joom/user_core_acl_aro.MYI
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: MyISAM file /var/lib/mysql/edisecur_joom/user_session.MYI
myisamchk: warning: 10 clients are using or haven't closed the table properly
myisamchk: MyISAM file /var/lib/mysql/eximstats/sends.MYI
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Found 138761 keys of 138908
myisamchk: MyISAM file /var/lib/mysql/eximstats/smtp.MYI
myisamchk: warning: Table is marked as crashed and last repair failed
myisamchk: Unknown error 126
myisamchk: error: Can't read indexpage from filepos: -1


root@server [/var/lib/mysql]# myisamchk --silent --force --fast --update-state /var/lib/mysql/i*/*.MYI
myisamchk: MyISAM file /var/lib/mysql/impact_joom/j25_content.MYI
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: MyISAM file /var/lib/mysql/impact_joom/j25_session.MYI
myisamchk: warning: 1 client is using or hasn't closed the table properly


root@server [/var/lib/mysql]# myisamchk --silent --force --fast --update-state /var/lib/mysql/k*/*.MYI
myisamchk: MyISAM file /var/lib/mysql/korol_joom/user_core_acl_aro.MYI
myisamchk: warning: 3 clients are using or haven't closed the table properly


root@server [/var/lib/mysql]# myisamchk --silent --force --fast --update-state /var/lib/mysql/l*/*.MYI
myisamchk: MyISAM file /var/lib/mysql/loteriad_joomla/user_phocadownload.MYI
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: MyISAM file /var/lib/mysql/loteriad_joomla/user_phocadownload_user_stat.MYI
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: MyISAM file /var/lib/mysql/loteriad_joomla/user_session.MYI
myisamchk: warning: 1 client is using or hasn't closed the table properly


root@server [/var/lib/mysql]# myisamchk --silent --force --fast --update-state /var/lib/mysql/m*/*.MYI
myisamchk: MyISAM file /var/lib/mysql/mfa_wp216/wp_options.MYI
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: MyISAM file /var/lib/mysql/mfa_wp216/wp_statistics_date.MYI
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: MyISAM file /var/lib/mysql/mfa_wp216/wp_statistics_visits.MYI
myisamchk: warning: 1 client is using or hasn't closed the table properly


root@server [/var/lib/mysql]# myisamchk --silent --force --fast --update-state /var/lib/mysql/n*/*.MYI
myisamchk: error: File '/var/lib/mysql/n*/*.MYI' doesn't exist
myisamchk: error: File '/var/lib/mysql/n*/*.MYI' doesn't exist

Я пробовал перейти по этой ссылке:

https://forums.cpanel.net/f49/mysql-databases-only-backup-293142.html#post12

Все они сохраняют sql в одном каталоге. Каким будет самый простой и быстрый способ переназначить их на целевом сервере с соответствующими каталогами имен пользователей внутри / var / lib / mysql /?

Получил эти ошибки, когда запустил выше

root@server [~]# for i in `cat /root/mysql.txt`; do mysqldump $i >
/backup/db_backup/$i.sql; done
mysqldump: Got error: 1034: Incorrect key file for table 'user_core_adi_aro';
try to repair it when using LOCK TABLES
mysqldump: Got error: 1034: Incorrect key file for table 'user_components';
try to repair it when using LOCK TABLES
mysqldump: Got error: 1034: Incorrect key file for table 'user_core_adi_aro';
try to repair it when using LOCK TABLES
mysqldump: Got error: 1034: Incorrect key file for table 'bak_components';
try to repair it when using LOCK TABLES
mysqldump: Got error: 1034: Incorrect key file for table 'user_components';
try to repair it when using LOCK TABLES
mysqldump: Got error: 1034: Incorrect key file for table 'user_core_adi_aro';
try to repair it when using LOCK TABLES
mysqldump: Got error: 1034: Incorrect key file for table 'sys_refindex'; try
to repair it when using LOCK TABLES
mysqldump: Got error: 1034: Incorrect key file for table
'nuke_theme_tplfile'; try to repair it when using LOCK TABLES
mysqldump: Got error: 1034: Incorrect key file for table 'user_core_adi_aro';
try to repair it when using LOCK TABLES
mysqldump: Got error: 1034: Incorrect key file for table 'user_core_adi_aro';
try to repair it when using LOCK TABLES
mysqldump: Got error: 1034: Incorrect key file for table 'node'; try to
repair it when using LOCK TABLES