Moving wordpress blog to new place and new domain
Another client ask me to move their blog to new vps server, something new in this case is the operating system of their vps server :
OpenSolaris
Yup, I have little experience in this OS but I still accept the job for $10.
Here’s the steps :
Secure copy with scp
# scp /data2/jails/outside/usr/home/alamster/outside.tar.gz arasyid@72.233.106.191:/home/alamster
Extract the file
#gzip -dc outside.tar.gz | tar xvf -
Edit wp-config.php
#/opt/csw/bin/nano wp-config.php
Edit with suitable content.
Call MySQL
find out where mysql
# ps -eaf | grep mysql
mysql 8107 1 0 Apr 22 ? 5:26 /usr/mysql/5.0/bin/mysqld –user=mysql –datadir=/var/mysql/5.0/data –pid-file
# /usr/mysql/5.0/bin/mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9005
Server version: 5.0.67 Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> drop database demo;
Query OK, 10 rows affected (0.03 sec)
mysql> create database demo;
Query OK, 1 row affected (0.00 sec)
mysql> exit
Bye
Import db
# /usr/mysql/5.0/bin/mysql -uroot -p demo < pctoutside.sql
Search and replace in MYSQL
# /usr/mysql/5.0/bin/mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9007
Server version: 5.0.67 Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> use demo;
Database changed
mysql>
update wp_options set option_value=replace(option_value,’http://outside.demo.com’,'http://www2.demo.com’);
update wp_postmeta set meta_value=replace(meta_value,’http://outside.demo.com’,'http://www2.demo.com’);
update wp_postmeta set meta_value=replace(meta_value,’http://172.88.1.13′,’http://www2.demo.com’);
update wp_posts set post_content=replace(post_content,’http://172.88.1.13′,’http://www2.demo.com’);
update wp_posts set post_content=replace(post_content,’http://outside.demo.com’,'http://www2.demo.com’);
update wp_posts set guid=replace(guid,’http://outside.demo.com’,'http://www2.demo.com’);
update wp_posts set guid=replace(guid,’http://172.88.1.13′,’http://www2.demo.com’);
Finish
all things goes back to normal in new place and new domain.
P.S : I change the domain for education purpose
- move wordpress from local host
- moving wordpress to a new domain
- move wordpress site to new server job
- moving wordpress to new domain and hosting
- move blog from wamp to real server
- move domain wordpress mysql query
- update guid wordpress
- transfer mysql database new server wordpress link problem update
- moving wordpress in vps
- tips wordpress localhost ke hosting
- update guid wordpress wp_posts mysql
- update post_content set guid = replace
- update wp_posts set guid
- update wp_posts set guid = replace (
- update \wp_posts\ set \post_content\ = replace(
- wamp wordpress with my domain
- wordpress change domain query
- search replace mysql wordpress meta_value
- search replace guid wordpress
- replace wp_post wordpress hosting
Related posts:
- Install wordpress for home development : setting domain Previous post talk about install wamp as foundation tool...
- Migrating from hostmonster to fastdomain Almost 1 year with hostmonster, overall experience I feel...
- Install Wordpress at Home Hello everybody, at previous posts I’ve talk everything around...
- Step by step move drupal from localhost to drupal hosting : AddOn Domain Setting At previous post I have covered steps for domain...
- Fatal error: Allowed memory size of and Upgrade wordpress This error show up when I try to upgrade...
Related posts brought to you by Yet Another Related Posts Plugin.
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
