The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need Urgent Help, I'm in strange situation

Discussion in 'Database Discussions' started by rukhaiyar, Nov 26, 2013.

  1. rukhaiyar

    rukhaiyar Registered

    Joined:
    Nov 26, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Yesterday, my server's hdd got crashed and the hosting company replaced it with a new hdd and attached the old one to recover data. They installed the new hdd just as a new server, without cpanel or any other changes. Just by installing the Centos 6 x64.

    Afterwards, being very less knowledgeable to linux system, I somehow installed cpanel and transferred old files using rsync command. Now, cpanel installed with mysql 5.5, which have default storage system as MyISAM. And, my database tables were in innodb.

    Now, I can't downgrade Mysql to 5.1 and unable to change default storage engine as it gives this error upon restarting if i try to change it to Innodb:

    ERROR! MySQL server PID file could not be found!
    Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/kali.4hire.org.pid).

    Contents of /etc/my.cnf is

    Code:
    [mysql]
    no-auto-rehash
    [mysqldump]
    max_allowed_packet=16M
    [myisamchk]
    key_buffer_size=256M
    write_buffer_size=2M
    read_buffer_size=2M
    sort_buffer_size=256M
    [isamchk]
    key_buffer_size=256M
    write_buffer_size=2M
    read_buffer_size=2M
    sort_buffer_size=256M
    [mysqld_safe]
    skip-federated
    server-id=1
    log-bin=mysql-bin
    log-error="/var/log/mysqld.log"
    pid-file="/var/run/mysqld/mysqld.pid"
    [mysqld]
    max_allowed_packet=1M
    innodb_buffer_pool_size=2G
    local-infile=0
    key_buffer_size=180M
    thread_cache_size=8
    read_rnd_buffer_size=8M
    open_files_limit=1314
    table_cache=10K
    default-storage-engine=MyISAM
    long_query_time=4
    slow_query_log
    tmp_table_size=512M
    sort_buffer_size=4M
    read_buffer_size=4M
    max_heap_table_size=512M
    myisam_sort_buffer_size=64M
    query_cache_limit=32M
    max_connections=45
    join_buffer_size=1M
    innodb_file_per_table=1
    query_cache_size=512M
    sync_binlog=0
    Please help me out.
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    Can you please provide here full MySQL logs so that we can check what exact issues are you facing with the MySQL services.

    And if you want to set default table type InnoDB, You will have to add following line in your my/etc/my.cnf:

    Code:
    default-table-type=innodb
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Did you have account backups enabled on the system before the hard drive crashed? If so, restoring the accounts through these backup archives is the only supported restoration method. Restoring/moving individual files/directories may work, but you are likely to encounter issues. The manual method is only recommended if you do not have any backup archives to restore.

    Thank you.
     
Loading...

Share This Page