Skip to main content

WHM taking too much time to respond restoring backups and terminating accounts

Comments

10 comments

  • Infopro
    Your post reads like you've got 3 different issues. Restoring takes too long, Terminating takes too long, and your MySQL connection is dropping for some reason. How big of an account are you restoring, and how are you restoring it? Explaining your steps and providing more Info that leads to the issue might be helpful. Thanks!
    0
  • Lordemma
    The last thing I can remember I did was editing my etc/my.cnf file adding some lines. I guess the problem is with my sql. I tried restarting it ang got this error "Waiting for mysql to restart....................................................................finished. mysql has failed, please contact the sysadmin (result was "mysql is not running"). Please what can I do to resolve this ? sorry for my nob question please
    0
  • Lordemma
    I tried checking the error log on /var/lib/mysql/$(hostname).err via SSH but got an error "Permission Denied" please how can I access the log file ?
    0
  • cPanelMichael
    [quote="Lordemma, post: 1534581">I tried checking the error log on /var/lib/mysql/$(hostname).err via SSH but got an error "Permission Denied" please how can I access the log file ?
    You can not enter a log file name directly into the command line. You have to use a utility such as "cat" or "tail -f" to view it. EX: tail -500 /var/lib/mysql/$hostname.err
    Thank you.
    0
  • Lordemma
    Thanks for that! it works well now. But I guess my problem is with the etc/my.cnf file I edited. Can someone please provide me with a Good etc/my.cnf file I can just use to replace mine ? please help if you can please with probably the one you are using. Thanks
    0
  • Lordemma
    mysql is not running please my mysql is not running. I tried restarting it but got this error "Waiting for mysql to restart....................................................................finished. mysql has failed, please contact the sysadmin (result was "mysql is not running"). The error log is not giving me any tip as to whyy it's failing and I just edited my /etc/my.cnf file if that will fix it but to no avail. Please help. How do I resolve this ?
    0
  • Infopro
    This comment may be of some use to you: Re: MYSQL Configuration - cPanel Forums HTH! :)
    0
  • Lordemma
    here is what is in my cnf file [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 2M sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 64M open_files_limit=12048 [mysqldump] quick max_allowed_packet = 16M The log is not giving me any clue...I'm just getting fraustrated now..please help please [COLOR="silver">- - - Updated - - - [quote="Infopro, post: 1534782">This comment may be of some use to you: Re: MYSQL Configuration - cPanel Forums HTH! :)
    I have gone through that thread but no useful post. Please help. Thanks
    0
  • Lordemma
    root@bestservers [/]# tail -f /var/lib/mysql/$(hostname).err 131223 00:47:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 131223 0:47:34 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 131223 0:47:34 [Note] Plugin 'InnoDB' is disabled. 131223 0:47:34 [Note] Plugin 'FEDERATED' is disabled. 131223 0:47:34 [ERROR] Unknown/unsupported storage engine: InnoDB 131223 0:47:34 [ERROR] Aborting 131223 0:47:34 [Note] /usr/sbin/mysqld: Shutdown complete 131223 00:47:34 mysqld_safe mysqld from pid file /var/lib/mysql/bestservers.gurushost.com.pid ended
    0
  • cPanelMichael
    The primary error message I see is: [QUOTE][ERROR] Unknown/unsupported storage engine: InnoDB
    Are you sure there are no InnoDB references in your /etc/my.cnf file, and that there are no additional issues in your MySQL error log related to InnoDB? What version of MySQL is installed? Thank you.
    0

Please sign in to leave a comment.