Need Urgent Help, I'm in strange situation

rukhaiyar

Registered
Nov 26, 2013
1
0
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.
 

24x7server

Well-Known Member
Apr 17, 2013
1,894
91
78
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
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
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.