服务器 Gind.cn
  1. 服务器 Gind.cn
  3. cpanel帐户传输失败：错误：无法转储一个或多个数据库
Intereting Posts
调整出站stream量以控制Linux下载速度 会议要求去别人 为DHCPnetworking分配一个静态IP地址 Ubuntu部署工具包 专用服务器 – 通过服务器IP访问时，cgi-sys / defaultwebpage.cgiredirect 转移80至443在Nagios的困境 装载失败时防止根系统装满的最佳方法是什么？ 是否有任何程序loggingWindows 2003文件共享上的所有活动？ Nginx龙卷风组合导致502错误的网关错误 如果不通过套接字连接，如何连接MySQL服务器？ 在MSSQL 2008中远程恢复数据库 如何有条件地redirectDNS查询与dnsmasq？ 删除孤立的Windows 2000 Server域控制器（VerifyEnterpriseReferencestesting失败） mod_rewriteredirect到特定的WP页面 Windows 2008 R2任务计划程序由于未知原因触发了一个事件

cpanel帐户传输失败：错误：无法转储一个或多个数据库

通过传输实用程序传输多个帐户时出现此错误：

错误：无法转储一个或多个数据库

我被一个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

您可以从phpmyadmin修复受影响的数据库/表。 phpadmin应该在cpanel主页上提供。

1.login到phpMyAdmin

  1. select受影响的数据库。 如果你只有一个数据库，它应该默认select它，所以你不需要做任何事情。

  2. 在主面板中，您应该看到数据库表的列表。 检查需要修理的表格。

  3. 在表格下方的窗口底部，有一个下拉菜单。 select“修理表”

然后您可以成功转帐。