\n<\/p>\n
Step #1 -Backup Your WordPress Database:<\/h2>\nngg_shortcode_0_placeholder\n
Most hosting accounts include PhpMyAdmin which is what you will use to backup the WordPress database. The process 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.<\/p>\n
- \n
- Click on the database you need to back up. It will be located on the top left region of the screen.<\/li>\n<\/ul>\n
- \n
- Click on “Export” on the top tool bar of PhpMyAdmin.<\/li>\n<\/ul>\n
- \n
- Complete the following steps.<\/li>\n<\/ul>\n
<\/p>\n
- \n
- In the Export box make sure all of the tables are highlighted and if they’re not click on “Select All”<\/li>\n
- 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<\/li>\n
- Lastly, towards the bottom of the screen make sure you select “Save as file” and then type a file name that correlates to your website and click “Go”. That’s it, your Database should now be backed up on your local drive.<\/li>\n<\/ol>\n
\n
![\"JealousBrother.com\"](\"http:\/\/www.jealousbrother.com\/blog\/wp-content\/gallery\/jealousbrother-ads_1\/jealousbrotherblogbanner3.png\")
<\/a><\/p>\nStep #2 Transfer all of your WordPress files to the new server:<\/h2>\n
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<\/a> to complete this task which is free. If any of you would like me to add additional information on this step of the process please let me know and I’ll add it to this post.
\n<\/p>\nStep #3 Create a new Database on your new server\/host.<\/h2>\nngg_shortcode_1_placeholder\n
If you’re using Cpanel this task is extremely simple but should be a very similar process on other control panels.<\/p>\n
- \n
- Click on “MySQL database wizard”<\/li>\n
- Enter a Database name. This could be wordpress or anything else you’d like. Then click “next step”.<\/li>\n
- Enter a Username and Password. Note: The Password must be entered twice and make sure it’s secure. (variation of numbers,letters, and cases) Then click “next step”.<\/li>\n
- Select “All Privileges” and click “next step”. That’s It!<\/li>\n
- Important Note:<\/strong> Make sure you write down the Database Name, Username, and Password or you’ll have to go back and find that information later.<\/li>\n<\/ul>\n
\n<\/p>\nStep #4 Edit the WPCONFIG.php <\/h2>\n
ngg_shortcode_2_placeholder
\n
\nAt 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.<\/p>\n- \n
- Click on “File Manager”.<\/li>\n
- Select “Web Root” and make sure “show hidden files” is selected(May not be necessary but better safe than sorry).<\/li>\n
- 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)<\/li>\n
- Once you locate WPCONFIG you’ll need to click on the mouses right button and select “Edit”.<\/li>\n
- You now need to alter three (possibly four) different items in the file.<\/li>\n<\/ul>\n
<\/p>\n
- \n
- Database Name<\/li>\n
- Username<\/li>\n
- Database Password<\/li>\n
- Database Host (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)<\/li>\n<\/ol>\n
<\/p>\n
- \n
- Note on Charset Value:<\/strong> 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.<\/li>\n
- Charset Resource: The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!)<\/a><\/li>\n
- Save Changes to the file and you’re done.<\/li>\n<\/ul>\n
<\/p>\n
Step #5 Import your old Database tables into your newly added Database. (Important! See note on Option #1)<\/h2>\n
This is a step that caused some serious issues for me when I first tried transfering 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 couple 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.
\n<\/p>\nOption #1 Using PhpMyAdmin (Databases under 10mb in size) (IMPORTANT! I have been informed that the size limit has been increased in recent versions of PhpMyAdmin. The new limit is 100mb<\/b> in size.)<\/strong><\/h2>\nngg_shortcode_3_placeholder\n
Follow these steps when using PhpMyAdmin to complete the import.<\/p>\n
- \n
- Click on PhpMyAdmin within Cpanel and login.<\/li>\n
- Click on the Database you created 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.<\/li>\n
- Click on the “Import” tab located on the upper navigation toolbar.<\/li>\n
- Click on “Browse” and find the Database backup that you earlier saved to your local drive.<\/li>\n
- Click “Go” and let PhpMyAdmin handle the rest.<\/li>\n<\/ul>\n
Presuming you’re database backup was less than 10mb in size you should now be ready to roll.<\/p>\n
<\/p>\n
Option #2 Using BigDump<\/a> (Databases over 10mb in size)<\/strong><\/h2>\n
ngg_shortcode_4_placeholder
\n
\nOne of the WordPress blogs I transferred required the use of BigDump<\/a> 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<\/a> to complete the import.<\/p>\n- \n
- Create a temporary folder on your server using “File Manager” in Cpanel. The reccommended name for the folder is “Dump” but it doesn’t really matter.<\/li>\n
- Upload bigdump.php and your database backup(example – wordpress.sql) into the “Dump” temporary” folder.<\/li>\n
- You now need to edit bigdump.php with the same process 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 host, DB name, Username, and Password. Save changes!<\/li>\n
- You now need to load bigdump.php in your browser. Open your favorite browser and enter 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.<\/li>\n
- Click “Start Import” and let BigDump<\/a> go to work.<\/li>\n
- You will see an activity page and will see a prompt below the activity page informing you when BigDump has completed the task.<\/li>\n<\/ul>\n
Note: Make sure the encoding within the bigdump.php file matches that of the original database or you’ll likely have strange characters show up all over your website!
\n<\/p>\nFinal Step: Don’t forget about your Nameservers!<\/h2>\n
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\/host. It should be noted that a lot of other people suggest changing nameservers earlier in the process but I refrain from doing that because of some issues I had with DNS on my server the first time I attempted the transfer.
\n<\/p>\nIn Closing<\/h2>\n
\nI hope you found this article helpful and if anyone would like me to add more details on any of steps in the process please let me know. If you found this article helpful I would greatly appreciate you sharing it with others. You can use the sociable links above or share it on other networks that aren’t listed. Thank You! Also, make sure to sign up on Jealousbrother.com<\/a> and get involved in the rivalries!<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction: There are numerous articles that cover the process of transferring a WordPress blog from one server or host to another but I\u2019ve 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 help you get your WordPress blog transferred […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[107],"tags":[224,53,220,219,223,221,218,222],"class_list":["post-720","post","type-post","status-publish","format-standard","hentry","category-how-to-guides","tag-bigdump","tag-blog","tag-cpanel","tag-database","tag-import","tag-mysql","tag-phpmyadmin","tag-wordpress"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.jealousbrother.com\/blog\/wp-json\/wp\/v2\/posts\/720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jealousbrother.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jealousbrother.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jealousbrother.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jealousbrother.com\/blog\/wp-json\/wp\/v2\/comments?post=720"}],"version-history":[{"count":131,"href":"https:\/\/www.jealousbrother.com\/blog\/wp-json\/wp\/v2\/posts\/720\/revisions"}],"predecessor-version":[{"id":1927,"href":"https:\/\/www.jealousbrother.com\/blog\/wp-json\/wp\/v2\/posts\/720\/revisions\/1927"}],"wp:attachment":[{"href":"https:\/\/www.jealousbrother.com\/blog\/wp-json\/wp\/v2\/media?parent=720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jealousbrother.com\/blog\/wp-json\/wp\/v2\/categories?post=720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jealousbrother.com\/blog\/wp-json\/wp\/v2\/tags?post=720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- You will see an activity page and will see a prompt below the activity page informing you when BigDump has completed the task.<\/li>\n<\/ul>\n
- Charset Resource: The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!)<\/a><\/li>\n
- Note on Charset Value:<\/strong> 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.<\/li>\n
- Complete the following steps.<\/li>\n<\/ul>\n
- Click on “Export” on the top tool bar of PhpMyAdmin.<\/li>\n<\/ul>\n