Ошибка передачи учетной записи 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

Все они сохраняют 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