Few WordPress Tips I’ve learned

As you might’ve known, for the last 2 weeks, I spent a good chunk of time migrating about 20 blogs including SolSie.com to a different hosting service. Due to complain from the previous hosting company that we have exceeded the allowance of the computing resources.

It was an absolute daunting task to maintain the site presence and perform the move simultaneously, especially for large and complex blogs. I have learned few things that I’d love to share.

• When you receive complains from your hosting company about excessive resource consumption. Just perform an SQL check/repair data in your CPanel MySQL and furthermore, an optimization of your database could provide tremendous help.  

  Many of these performance related issues can be fixed very quickly through phpMyAdmin.

  Just follow these steps: (Note: It is always a good idea to back up your database before making any changes)

  1. Log into your cpanel.
  2. Click on phpMyAdmin.
  3. On the left will be a list of your databases. Select the one you want to repair/optimize.
  4. This will load all of the tables in your database into the right side. At the bottom of this list, there is a link called "Check All". Click that.
  5. Just to the right of the check all link there is a drop down menu that says "With Selected." Click on that, and choose "repair".
  6. You should get a page that will list all the tables, with "OK" listed next to them. When this is done, look up to the top of the page, and click on the "Structure" tab.
  7. This will take you back to the page you saw on step 4.
  8. Click "Check All" again, and then choose "Optimize" in the drop down menu.

  

You should see the same page as in step 6. You’re done!

Many MySQL errors can be fixed by this process. It is recommended to perform these steps frequently to keep your database in good condition.

• Bring your current blog to the latest WP version, since most likely you have to install a fresh new WP at your new location before the migration . Both source and target should be at the same level. The Worpress –Tool – Upgrade works very good for me.

• The WordPress – Tools – Export – Import works well when you have small blogs (less than 20MB). When the XML export file is larger than 20MB, you should contact your hosting provider to enlarge that limitation. If your blog is large and complex You might want to backup your SQL database using your CPanel File Backup and import with your phpMy Admin as described HERE

• Save your sidebar html code somewhere. I have seen in many cases, the sidebar Widgets are not carried over. Also save the WP-Content directory

• Sometime, I lost track which SQL database is connected to which blog. A good trick I found is to go to the phpMyAdmin (as seen in the above photo); select the database you want to inspect; on the 3rd line wp_options; click on the left icon (browse) in the action column. The SiteURL will tell you what blog it is connected to.

I hope you could benefit few things here for your next move!

Comments

Leave a comment

Name (required)

E-mail (required)

URI

Your Comment

Notify me of followup comments via e-mail