What I’m doing – Moving WordPress Sites

Posted on by Donald in Adventure, How-To, Life, To-Do Leave a comment

We’ll I think I’ve come to the point where I can say I’ve mastered WordPress Blogs. I think I can say that because one, I have over 50 wordpress blogs now, each with their own domain and content. Most content are unique guides for MMORPG games, and others are news blogs, spitting up post based on keywords I feed them. And two, for the past week I’ve been moving most of my sites to my new server at The Planet, which I must say is awesome so far!

In order to move a blog, you must first move all files over to the new host. This it self can take 10-20 minutes depending how many files you have and the software used to move them. I highly recommend using GlobalSCAPE CuteFTP 8.0. I’m using CuteFTP to move the final 4 sites I have on my to-do list.

The PlanetOnce your files are moved you then need to create a backup of your database from your old host to import to the new host. This is pretty straight forward. Simply use phpMyAdmin which both host should have to create the backup and import. If you host doesn’t have this already installed, then you’ll have to install phpMyAdmin your self, which I found to be somewhat of pain the first time I tried to do it. Actually it wasn’t so bad, but the instructions I had were horrible! I hate when people assume you know what they’re talking about when trying to show you how to do something. It makes things so much harder to do, for me at least! Anyways, if you’re having trouble with phpMyAdmin you can use Putty if you have root access to your host. You can read my Using Putty To Import A Database post if you want to learn how to do that.

So that’s what I’m doing right now and for the past week. Moving my wordpress blogs! I only have 4 left! I’m so happy I’m almost done. You may think it’s easy, but moving a butt load of sites in less then a week isn’t. It takes my about 30 to 60 minutes to move one site. That’s only if I don’t have any problems with the files, database, DNS, ISP, Server Issues, or any other random glitches. So far it hasn’t been so bad.


Using Putty To Import A Database

Posted on by Donald in Database, How-To 7 Comments

Do you have a database too big to import using phpMyAdmin? Well if you have root access, you can use Putty to import a database for you. If you’ve never used Putty before it could be daunting task the first time, I know it was for me. But after learning the basics and one of the most import features, its cake now!

Using putty ~

One trick that basically got me started was being able to copy and paste! It’s actually fairly easy, but not obvious. Simply copy the text your want to use from any location, and right click into putty to paste. Note: When pasting a password your password won’t show up after right-clicking. It’s there, but you can’t see it.

So to paste into Putty, simply right click your copied text in the window and that’s it.

Once you’re logged into your server using Putty. Ask your server admin if you’re having trouble doing this, its cake to import your database.

First you’ll need to make sure the database you want imported is uploaded to your website directory. Using any of your favorite FTP programs, upload the SQL file now. This would be your database backup file.

puttyOnce your SQL file is uploaded, your need to change your Putty directory to the location where you file is located.

To change your directory in Putty, use the cd command followed by the directory you want to change to. For me the command would be:

cd /var/www/vhosts/aspkin.com/httpdocs

This takes me to aspkin.com httpdocs directory where my SQL file would be located.

Your command would be similar to this depending on your server. Ask your server admin for path information to your httpdocs directory if you need it. If your SQL file is located here, you’re half way done!

Using the dir command, you can see what files you have in your directory. Try it now.


If you see your SQL file, that’s good. If not, change your directory to find your file.

Once you’ve found your file use this command to import your SQL file to your database.

mysql -u dbusername -p databasename < backupname.sql

Make sure to change dbusername, databasename, and backupname.sql to your data.

Once you use this command, you’ll be prompted for your database password. Enter that and your database will be imported!


P.S. Using phpMyAdmin you can check to see that all tables have been imported and you’re good to go.

« Previous   1 2 3