Check apache conf and dns entry for the domain having issue.
if there is any missing entries in apache conf
Take a copy of the apache conf and rebuild the conf.
make the below changes on whm > tweak settings.
> Domains > Proxy subdomains [?] > on
Proxy subdomain creation [?] > on
Proxy subdomain override [?] > on
Saturday, October 29, 2011
link mysql to /home
How to Change the location of MySQL:
1) Stop MySQL using command: service mysql stop
2) cp /var/lib/mysql /home/mysql
3) vi /etc/my.cnf
change the below settings.
[mysqld]
set-variable = max_connections=500
datadir = /home/data/mysql
pid-file = /home/mysql/mysqld.pid
skip-locking
safe-show-database
skip-bdb
old_passwords=1
long_query_time=2
log-slow-queries=/var/log/mysql-slow-queries.log
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=50
max_connections=500
thread_cache_size=256
table_cache=8192
key_buffer=64M
max_connect_errors=20
max_allowed_packet=128M
join_buffer=2M
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=1M
thread_concurrency=16
myisam_sort_buffer_size=64M
then save the file
4) chown -R mysql:mysql /home/mysql
5) rm /tmp/mysql.sock
6) ln -s ../../home/mysql/mysql.sock /tmp/mysql.sock
7) Run Command: service mysql restart
Now MySQL should be successfully started and operating from the location /home/mysql
You can remove the old mysql directory by using rm -rf /var/lib/mysql
1) Stop MySQL using command: service mysql stop
2) cp /var/lib/mysql /home/mysql
3) vi /etc/my.cnf
change the below settings.
[mysqld]
set-variable = max_connections=500
datadir = /home/data/mysql
pid-file = /home/mysql/mysqld.pid
skip-locking
safe-show-database
skip-bdb
old_passwords=1
long_query_time=2
log-slow-queries=/var/log/mysql-slow-queries.log
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=50
max_connections=500
thread_cache_size=256
table_cache=8192
key_buffer=64M
max_connect_errors=20
max_allowed_packet=128M
join_buffer=2M
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=1M
thread_concurrency=16
myisam_sort_buffer_size=64M
then save the file
4) chown -R mysql:mysql /home/mysql
5) rm /tmp/mysql.sock
6) ln -s ../../home/mysql/mysql.sock /tmp/mysql.sock
7) Run Command: service mysql restart
Now MySQL should be successfully started and operating from the location /home/mysql
You can remove the old mysql directory by using rm -rf /var/lib/mysql
Subscribe to:
Posts (Atom)