CHAPTER 18 MAINTAINING YOUR BLOG 495 Tip (Web hosting comparison)
CHAPTER 18 MAINTAINING YOUR BLOG 495 Tip If you re moving your WordPress blog to a new hosting provider, you ll need to first create the database as you did in Chapter 14. To make things easy for yourself, name the database exactly as in your previous installation. Navigate your web browser to the phpMyAdmin page for your database. It should look similar to Figure 18-4, which shows the WordPress tables. Figure 18-4. The WordPress database tables in phpMyAdmin Choose the SQL tab at the top of the page, and you will see a page like the one shown in Figure 18-5. Here, you can enter a query in the large text area in the top part of the page or choose a text file to upload by clicking the Choose button next to the Location of the textfile box. Notice that there is a maximum file size indicated, which is 8MB in the example shown in Figure 18-5. Your limit may differ from this, but the general rule is that uploading files of around 3MB and above usually proves unsuccessful. In this event, you re forced to cut segments from the text file to paste into the text area of the SQL tab, one piece at a time, until the whole file has been completed. Note Prior to populating the WordPress databases with your backup, you ll need to ensure that all the current information in there is removed by using the DROP TABLE command in MySQL. The process used by the WP-DB Backup plug-in does this for you when restoring the backup.
In case you need quality webspace to host and run your web applications, try our personal web hosting services.