서버 IP 변경 후 XE 설정

XE IP 변경

 

1. mysql ip 변경

 

[root@~]# mysql -u root -p
Enter password:

mysql>

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
| xe                 |
+--------------------+
4 rows in set (0.00 sec)

mysql>

mysql> use xe;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>

mysql> select * from xe_sites;
+----------+------------------+--------------+------------------+----------------+
| site_srl | index_module_srl | domain       | default_language | regdate        |
+----------+------------------+--------------+------------------+----------------+
|        0 |               65 | x.xxx.xxx.xx | ko               | xxxxxxxxxxxxxxx |
+----------+------------------+--------------+------------------+----------------+
1 row in set (0.00 sec)

mysql>

mysql> update xe_sites set domain='y.yyy.yyy.yy' where site_srl='0';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql>

mysql> select * from xe_sites;
+----------+------------------+--------------+------------------+----------------+
| site_srl | index_module_srl | domain       | default_language | regdate        |
+----------+------------------+--------------+------------------+----------------+
|        0 |               65 | y.yyy.yyy.yy | ko               | xxxxxxxxxxxxxxx |
+----------+------------------+--------------+------------------+----------------+
1 row in set (0.00 sec)

mysql>

 

 

 

2. xe db config file 수정

 

[root@~]# vi /xe/files/config/db.config.php

 

26행

'default_url' => 'http://y.yyy.yyy.yy/',

 

[root@~]#

 

 

완료!!!