Tag Archives: database

How to Migrate your WordPress Blog from One Hosting to Another

Web-hosting is one of the most crucial parts of any website. A bad web hosting may bring lots of downtimes, and it’s not good for your online business. WordPress is one of the most popular blogging platforms and no doubt it’s memory hogging software.

Especially if you are using free web hosting, within some time, you might face lots of issues with your hosting. Best advice would always start by picking one of the best WordPress Hosting sites.

This tutorial is for all those who are looking to migrate their server from one host to another host.  Migrating WordPress blog from one host to another is not some rocket science, and with a good piece of tech knowledge, you can perform the hosting migration yourself.

Steps:

1) Taking Your Database backup

  • Login to your host cPanel
  • Go  to your MYSQL/PHP MYADMIN, where you have the actual database of your site
  • Click on Export  in PHPMYADMIN

 

  • Take a backup of all the tables in SQL format

 

2) Downloading a copy of Wp-content folder

  • Login to your FTP
  • Go to your WordPress files
  • Download Wp-Content folder to your hard drive (Even you can drag wp-content folder to your Desktop to download)

3) Installing WordPress on new server

  • Install  WordPress on your new host (Automatically through Fantastico from cPanel or WordPress  Manually)
  • Now login to your new host FTP
  • Delete wp-content from the set of  WordPress files

  • Transfer  the backed up  Wp-content folder via FTP to your host

4) Import Database

  • Login to your new host
  • Go to MYSQL/PHP MY ADMIN
  • Click on Import
  • Select the exported file using CHOOSE FILE option

  • Click on  ‘Go’ to import it

5) Change Name Servers

  • Login to your client area of Domain Registrant.
  • Go to Domain Management.
  • Look for DNS and go there.
  • Change the name servers to your new host.

Note:

Name server changes will take some to propagate and reflect worldwide. So wait for 2-24 hours for complete name server propagation.

I hope this tutorial will help you with your WordPress hosting migration but if you have any more queries regarding web hosting or host migration, feel free to ask via comments.

How to Backup and Transfer your Picasa Database in Windows 7

Picasa is free photo editing software from Google that lets you modify your pictures and tag them. Picasa stores its information in its database. If you want to transfer your Picasa settings and tags to a new computer, then not only will you have to transfer the photos but also the database to the new folder.

Picasa backup

In Windows 7, transferring Picasa database is quite simple. First, head on over to the following foder:

C:> Users > [Your User Name] >AppData > Local > Google

You will see a folder titled either Picasa2 or Picasa3. Right click on this folder and copy it.

picasa

To create a backup, simply paste the folder in a safe storage location.

To transfer the database to a new computer, paste the copied folder to an external storage device like a flash drive. Plug the flash drive into the new computer. The Picasa folder you pasted into the flash drive should now be copied to the same folder location in the new computer:

C:> Users > [Your User Name] >AppData > Local > Google

This action will transfer your Picasa database from the first computer to the second computer.