WordPress Migration

How to move WordPress to a new site

1. Backup the webpages and database (for instance, the database is saved as wp_db.sql)

2. copy the webpages and the database to the destination site.

3. create database on the new server site
3.1 mysql -p (password), and enter the password
3.2 mysql> create database “wordpress_db”;
i.e.:”wordpress_db” means the database of the worpress website. NO NEED OF “”

4. input the database: mysql -p “wordpress_db” < wp_db.sql

5. If the MYSQL login/password is changed, we should have to change the following items.
// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘wp_en’);

/** MySQL database username */
define(‘DB_USER’, ‘root’);

/** MySQL database password */
define(‘DB_PASSWORD’, ‘goalbit’);

/** MySQL hostname */
6. Extract the webpages to the destination site
6.1 /etc/httpd/sites-enabled to create a file
6.2 A sample of the config file as
[root@suitehk sites-enabled]# cat solarsystems.net
<VirtualHost *:80>
ServerName www2.thesolarsystems.net
DocumentRoot /home/jerry/www/solarsystems
</VirtualHost>

<Directory /home/jerry/www/solarsystems>
Options FollowSymLinks
Allow from all
</Directory>
6.3 REMINDED: chmod 755 on the /home/jerry/www/solarsystems, especially the home directory is drwx—— at CENTOS’s user home directory…