Blog Flip - Transferring a Wordpress Site.

Hi All,

I was reading this post http://www.warriorforum.com/main-int...heres-how.html and the question was asked about transferring a Wordpress site to another host.

NOTES:

1. This assumes that you have transferred the domain and the DNS is resolved. You can run into issues if you do this and the DNS has not resolved yet.

2. This assumes that the purchasers hosting has Fantistico to install wordpress. If not, you can still follow most of this, just have install Wordpress manually.

Here is what I do:

Before the DNS is Transfered
---------------------------
1. Download everything in the public folder (typically public_html)

2. In the cpanel, go to phpMyAdmin. Something like this: http://DOMAIN.com:2082/3rdparty/phpMyAdmin/index.php

3. Click on the wordpress database. Make note of the database name something like youruser_dbname. You need to know the stuff before the underscore (_)

4. Click on the EXPORT tab

5. Check "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION" in the Structure Area of Options

6. Make sure SQL is selected in the Export Area

7. Click GO at the bottom right. This exports all the tables into an SQL text box.

8. Copy and paste the output into a text editor and save.

AFTER the DNS Transfer
------------------------

A. Log into the clients CPANEL and setup wordpress using Fantastico. Many of the options like admin username, password, site name, don't matter because you will be over writing them later.

B. At the end of the installation, make you note the database name. It will be something like yhe123_dbtable. You need to know the stuff before the underscore (_)

C. Open the SQL file you saved in step 8 above in a text editor.

D. Do a find on your username from step 3 above. Replace with the clients username from step B above.

E. Copy all.

F. Go to their phpMyAdmin

G. Click on the wordpress database on the left.

H. Click on the SQL tab

I. Paste the SQL you copied from step E into the box. It might take a little time to paste as it is having to load it into the server.

J. Click GO at the bottom right. It may take awhile. When it is done, it will say something to the effect that it is done.

K. Upload the files from step 1 above to their server.

You should be done!

The only area that may not work is the password. If you get a "cannot connect to database error" Then, I have just set up another user for the database with the password from the original install. Does someone have a better (I am sure there is) than this?

NOW, you will have to change all the affiliate IDs.

The easy way would have been to create generic IDs in the original site. For instance,

TTADSENSEIDTT
TTCLICKBANKTT
TTEBAYTT

Then when doing the find/and replace of the SQL file, you do all this at the same time! Upload the SQL and Voila. Done!

One of the keys to flipping sites is to do things as fast as you can. Time is definitely money.

You need to use automation.

1. Get familiar with Imacros for Firefox (iMacros for Firefox - Script your Firefox Web Browser) such an awesome program. Runs in the browser. This is Free

2. MacroExpress.com. if you can click in a window (any window) it can run! You have to pay. There is another one that is also pay but I don't have it and can't remember the name.

3. Clipmate.com (clipboard on steriods). Paid. I know there is a free one out there, but I don't know what it is called. Someone?

Here is an example. In WordTracker, to do a competitive analysis, you have to paste in only 10 keywords at a time! Yikes. What if you have 10,000 keywords?

I have a MacroExpress macro that takes all the 10K keywords and copies them into 10 kw packages into Clipmate.

I set up a file the Imacros can read.

Imacros takes them and I go get coffee, mow the law. When I am back, 10K keywords researched!

It would have taken me hours and hours to do this manually. With the Macros, you are down to literally minutes.

A warrior made a really good post on automation. I can't find it. He also has a WSO, I think on using Imacros. Worth it! It is packaged with Ultimate Article Marketing by Jack Duncan. http://www.warriorforum.com/warrior-...ting-list.html

Also, Kate Anderson's Blog Flipping WSO is outstanding. http://www.warriorforum.com/warrior-...ney-today.html

OK. I think I covered it.

Blessings and GO Do It!

Ed