linux运维、架构之路-数据库迁移

cd /server/tools/
wget https://cn.wordpress.org/wordpress-4.8.1-zh_CN.tar.gz
tar xf wordpress-4.8.1-zh_CN.tar.gz
mv wordpress/* /application/nginx/html/blog/
chown -R www.www /application/nginx/html/blog/

注意：确认hosts文件进行了解析
浏览器页面输入blog.etiantian.org/进行wordpress部署        
vim wp-config.php可以修改wordpress上的数据库连接参数信息

create database wordpress;
grant all on wordpress.* to ‘wordpress‘@‘172.16.1.%‘ identified by ‘123456‘;
select user,host from mysql.user;
grant all on wordpress.* to ‘wordpress‘@‘localhost‘ identified by ‘123456‘;
flush privileges;

wordpress Discuz DedeCMS……等开源软件

mv ./* /application/nginx/html/blog/

chown -R www.www /application/nginx/html/blog/

create database wordpress;
grant all on wordpress.* to ‘wordpress‘@‘172.16.1.%‘ identified by ‘oldboy123‘;
grant all on wordpress.* to ‘wordpress‘@‘localhost‘ identified by ‘oldboy123‘;
flush privileges;

mysqldump -uroot -p123456 --all-databases >/tmp/bak_$(date +%F).sql

scp -rp /tmp/bak_2017-09-25.sql 172.16.1.51:/tmp/

mysql -uroot -p123456 </tmp/bak_2017-09-25.sql
flush privileges;

vi wp-config.php 
注：修改localhost为远程db01的数据库IP地址
此时web服务器的数据库就可以停止服务了，至此数据库迁移完毕

/application/nginx/html/blog/wp-content
mkdir /tmp/wordpress_backup -p
mv uploads/* /tmp/wordpress_backup/

echo "/data 172.16.1.0/24(rw,sync,all_squash)" >>/etc/exports
/etc/init.d/nfs restart
showmount -e 172.16.1.31
mount -t nfs 172.16.1.31:/data /application/nginx/html/blog/wp-content/uploads/
mv /tmp/wordpress_backup/* .

[root@web01 extra]# cat blog.conf 
    server {
        listen       80;
        server_name  blog.etiantian.org;
        location / {
            root   html/blog;
            index index.php index.html index.htm;
        }
        location ~ .*\.(php|php5)?$ {
            root   html/blog;
            fastcgi_pass  127.0.0.1:9000;
            fastcgi_index index.php;
            include fastcgi.conf;
        }
    }