How to move WordPress From One Server Or great number to Another
There are numerous articles that cover the time of action of transferring a WordPress blog from one server or great number to another but I’ve found that most of them left me asking questions after reading them. I am a very visual person and hope the following article and images (Article with images obtainable: Link is below this article) help you get your WordPress blog transferred successfully. The following article was compiled from firsthand experience of transferring two WordPress blogs from a Godaddy hosting account to my own dedicated linux server.
Step #1 -Backup Your WordPress Database:
Most hosting accounts include PhpMyAdmin which is what you will use to backup the WordPress database. the time of action really isn’t that difficult. The first thing you’ll need to do is find PhpMyAdmin within your hosts control panel. After you’ve logged into PhpMyAdmin you’ll need to do the following.
- Click on the database you need to back up. It will be located on the top left vicinity of the screen.
- Click on “Export” on the top tool bar of PhpMyAdmin.
- Complete the following steps.
- In the Export box make sure all of the tables are highlighted and if they’re not click on “Select All”
- In the Options box make sure to select the following options in addition to the default settings. 1.) Add DROP TABLE/VIEW/PROCEDURE/FUNCTION 2.) Add AUTO_INCREMENT value 3.) Enclose table and field names with backquotes 4.) Complete inserts 5.) Use Hexadecimal for BLOB
- Lastly, towards the bottom of the screen make sure you select “Save as file” and then kind a file name that correlates to your website and click “Go”. That’s it, your Database should now be backed up on your local excursion.
Step #2 move all of your WordPress files to the new server:
For the time being I’m not going to cover this step in extreme detail because there are so many different ways this can be done. I chose to use the FTP client FileZilla to complete this task which is free. If any of you would like me to add additional information on this step of the time of action please let me know and I’ll add it to this article.
Step #3 Create a new Database on your new server/great number.
If you’re using Cpanel this task is extremely simple but should be a very similar course of action on other control panels.
- Click on “MySQL database wizard”
- go into a Database name. This could be WordPress or anything else you’d like. Then click “next step”.
- go into a Username and Password. observe: The Password must be entered twice and make sure it’s obtain. (variation of numbers,letters, and situations) Then click “next step”.
- Select “All Privileges” and click “next step”. That’s It!
- Important observe: Make sure you write down the Database Name, Username, and Password or you’ll have to go back and find that information later.
Step #4 Edit the WPCONFIG.php
At this point you should have already copied all of your WordPress files to the new server and we now need to modify the WPCONFIG.php file with the new Database information. Once in Cpanel you need to complete the following steps.
- Click on “File Manager”.
- Select “Web Root” and make sure “show hidden files” is chosen(May not be necessary but better safe than sorry).
- Find WPCONFIG.php within the file manager. Depending on where you copied the WordPress files on the server this file should be located in WordPress’s root directory. (Meaning it’s not located in wpcontent or wpadmin, it’s located in the same directory as all of the WordPress folders)
- Once you locate WPCONFIG you’ll need to click on the mouses right button and select “Edit”.
- You now need to alter three (possibly four) different items in the file.
- Database Name
- Database Password
- Database great number (If you’re hosting WordPress on your own server this should be localhost but may vary depending your hosting situation. If you’re unsure you’ll need to contact your administrator)
- observe on Charset Value: This value must match the value of your old Database. I left it at the default setting and everything worked correctly but I have read that having an incorrect charset can cause compatibility issues within the Database.
- Save Changes to the file and you’re done.
Step #5 Import your old Database tables into your newly additional Database.
This is a step that caused some serious issues for me when I first tried transferring a WordPress blog. Whithout completing this step your new database will not function because it doesn’t contain any of the tables or information from your WordPress powered website. There are a associate of options to complete this task and your choice should very based on the size of your database backup. If you’re database is larger than 10mb in size you’ll likely need to use third party software to complete the task. If you’re Database backup is smaller than 10mb in size you can use PhpMyAdmin to complete the import.
Option #1 Using PhpMyAdmin(Databases under 10mb in size)
Follow these steps when using PhpMyAdmin to complete the import.
- Click on PhpMyAdmin within Cpanel and login.
- Click on the Database you produced earlier. This database should have a zero next to it representing that it doesn’t contain and tables. It should in the upper left hand side of the screen.
- Click on the “Import” tab located on the upper navigation toolbar.
- Click on “Browse” and find the Database backup that you earlier saved to your local excursion.
- Click “Go” and let PhpMyAdmin manager the rest.
Presuming you’re database backup was less than 10mb in size you should now be ready to roll.
Option #2 Using BigDump(Databases over 10mb in size)
One of the WordPress blogs I transferred required the use of BigDump which is an amazingly useful tool. Don’t be scared to use it, it’s extremely easy to use. Follow these steps if you’re using BigDump to complete the import.
- Create a permanent folder on your server using “File Manager” in Cpanel. The recommended name for the folder is “Dump” but it doesn’t really matter.
- Upload bigdump.php and your database backup(example – WordPress.sql) into the “Dump” permanent” folder.
- You now need to edit bigdump.php with the same course of action you used to edit WPCONFIG.php earlier. Use file manager within cpanel, right click on bigdump.php, click “edit”, and then proceed to modify DB great number, DB name, Username, and Password. Save changes!
- You now need to load bigdump.php in your browser. Open your favorite browser and go into the location of bigdump.php (example: http_//www_yourdomain_com/dump/bigdump.php) Once loaded you’ll see the BigDump menu and you should see your database backup listed.
- Click “Start Import” and let BigDump go to work.
- You will see an activity page and will see a prompt below the activity page informing you when BigDump has completed the task.
Final Step: Don’t forget about your Nameservers!
Depending on your situation you will likely need to alter your Nameservers with your domain registrar. In some situations you can continue to use the Nameservers provided by the domain registrar as long as you make the necessary modifications on your new server/great number. It should be noted that a lot of other people suggest changing Nameservers earlier in the time of action but I refrain from doing that because of some issues I had with DNS on my server the first time I attempted the move.
I hope you found this article helpful and if anyone would like me to add more details on any of steps in the time of action please let me know. If you found this article helpful I would greatly appreciate you sharing it with others.
If you would like to view this article with images, click here: Article with Images