Transferring WordPress site
I recently transferred this WordPress site (amitabhjotwani.com) to a new host. Although I knew it would involve transferring the database (Word press stores all the content in a database) as well as the actual files, I wasn't quite sure how to go about it. So began my quest for an answer...and as is the norm...a website called Google came to the rescue...anyways...long story short...while there are plenty of websites out there explaining how and what to transfer...it took me a little while to gather all the information and create a step by step process for the transfer. Here's a quick summary of what I discovered needs to be done to ensure a smooth transition -
1. First you want to copy all the word press files from the old host to your computer using your favorite FTP program (I used the awesome and free File-Zila)
2. Next you want to back up the word press database from the old host using either the word press database backup plugin or using phpmyadmin provided by your old host. For some reason myphpadmin did not work out for me and I used the plugin. It is very easy to install and use. Export the database to a SQL file on your computer.
3. Now you want to create a new database on the new host. Make sure you note the details of the new database like database name, username, password etc. We will need this to configure the WP-config.php file later.
4. Now Import/restore the database using phpmyadmin on your new host. This would involve importing the SQL file you created in step2.
Note: If u get the following error while importing, Search and delete all instances of the phrase "DEFAULT CHARSET=latin1" from the sql file and import again.
"You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‚ÄòDEFAULT CHARSET=latin1?
5. Copy the WordPress files that you copied from the old host in Step1.
6. Now update wp-config.php located on the root folder on the new host with the appropriate database information.
7. Change the DNS information so that the domain name now points to the new location.
You can find more detailed instructions here