At my darkest hour during migration, this tutorial helped me see the light (click here). Now, I will share my own experience during while migrating wordpress blog to a new host.
I started with FTP to transfer my files. I used Filezilla since it’s a FREE FTP Software.
I download the file from /public_html and save it to my computer then upload the file to the new host.
After that I downloaded the Database from my old host. I always thought that this was the hardest part but after following the tutorial from the link above, I realized I was just misinformed LOL
So here’s how I did it:
From the cpanel, go to phpMyAdmin:
It will open to a new tab and will ask for your log in details (hosting account lo in details).
This is how phpMyAdmin looks:
Notice how my database were named as such.. and with more than 20 databases listed, I had a hard time looking for the database that I am transferring. What I did was to look in each of the database and check the wp-user folder to know which database belongs to which blog. But since I used admin in most of my blogs, I had to change the log in details of each blogs so that it would be easier for me to identify the database.
At the left side, you can see the database names, click on the database that you want to download then click the EXPORT button. Follow the steps in the photos:
Scroll down and click the GO button to download the file to your computer.
After downloading the copy of the database, log in to your new host, then CREATE a new database:
From the cpanel of your hosting account, go to MySQL® Databases:
HOW TO CREATE A NEW DATABASE:
- Create a new database, name your new database. I suggest that you use the domain of the blog you are transferring or part of it for identification purposes.
- Add New User. Use part of the domain of the blog or the domain itself, also for identification purposes. Take note of the username and the password, you will need that later.
- Add User to Database. Add the user you created to the database that you just created.
- Click ALL PRIVILEGES after the prompt
After that, go to phpMyAdmin then import/upload the database you downloaded a while ago:
Click on the name of the database then click IMPORT.
After importing the database, change the upload path:
- Click the wp_options, then click BROWSE, then click page 2
- Look for upload_path then edit it.
- Use the account name of your new host (/home/HOSTING ACCOUNT NAME/public_html/wp-contents/uploads)
To synchronize your files and database, you will need to open the files from /public_html (the files you uploaded)
- Go to FILE MANAGER, then click public_html.
- Click the blog/file that you uploaded, the click wp-config and click edit (top area)
- Replace the Database name, the database user and the database password:
The last thing you need to do is to ASSIGN the domain name to your new host. Go to DOMAIN assign a new domain to your account, then assign the domain of the blog you wish you transfer (you will be asked for the password from your old account).
and you’re done!