Need Urgent Help, I'm in strange situation
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
Please help me out.
[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=0Please help me out.
-
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: default-table-type=innodb0 -
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. 0
Please sign in to leave a comment.
Comments
2 comments