I used 2 days to learn and solved the errors.
Day 1
Welcome to GatorChat!
You are being connected to a representative in our Technical Support department right now.
For immediate answers to your questions, check out our knowledge base and video tutorials at http://support.hostgator.com.
Your Chat ID is 3088963.
Hi, my primary domain is mydomain.com. I would like to test my addon domain that might be going to be transferred from other wordpress.org host. I have done all the work, now is testing time. My addon domain is bestleadsconversiontraffic.com. Please also test the subdomain at bestleadsconversiontraffic.com/blog/.Once tested, I then can proceed to name the name server and pointing to Hostgator.
(07:17:21 PM) System: There are currently 25 people in front of you and 79 chat technicians assisting customers.
(07:17:30 PM) Matthew Je: has entered the chat.
(07:17:34 PM) Matthew Je: Hello, welcome to HostGator Live Chat.
(07:17:43 PM) Matthew Je: One moment please while I review your question Henry.
(07:17:52 PM) Henry: thx
(07:18:27 PM) Matthew Je: You’re simply trying to set up this addondomain.com/blog with the temporary URL for testing, correct Henry?
(07:18:53 PM) Henry: Temporary?
(07:19:23 PM) Henry: Both are usable…it is a valid domain registered with Godaddy
(07:19:35 PM) Matthew Je: You mentioned the nameserver were not pointed, because of this we would need to use the temporary URL to test the sites. Is this incorrect?
(07:19:59 PM) Henry: I had been doing this before for thenexttrillions.com and already in Hostgator
(07:20:40 PM) Henry: I think so…because I dunno how your do it
(07:20:57 PM) Henry: Is ur expertise 
(07:21:00 PM) Matthew Je: I’d be more than happy to walk you through the process Henry. Are you able to log into the cPanel?
(07:21:11 PM) Henry: I am there
(07:21:51 PM) Matthew Je: Wonderful, from there would you select “phpMyAdmin” under Databases.
(07:22:20 PM) Henry: ok in
(07:22:51 PM) Henry: Select main addon domain?
(07:23:08 PM) Matthew Je: You’ll be selecting the Database for this installation.
(07:23:15 PM) Matthew Je: Where do you see the option for Main AddOn Domain?
(07:23:38 PM) Henry: Ok..the DB of the domain..in
(07:24:08 PM) Henry: I remember its DB in relation with the domain
(07:24:10 PM) Matthew Je: That’s correct, if you don’t have that on file you could view this in the “wp-config.php” file underneath that AddOn domain.
(07:24:37 PM) Henry: Ok..cool!
(07:25:27 PM) Matthew Je: Once you’ve selected to open that database let me know Henry.
(07:25:37 PM) Henry: Already..wait for u
(07:25:56 PM) Matthew Je: Would you navigate to the wp-options table for me please, and we’ll be updating two URLs.
(07:26:34 PM) Henry: Point to Wp option…next
(07:26:36 PM) System: This chat is no longer active. You can rate it or start a new chat. [ Too many connections on my ISP address ]
Continue…
Welcome to GatorChat!
You are being connected to a representative in our Technical Support department right now.
For immediate answers to your questions, check out our knowledge base and video tutorials at http://support.hostgator.com.
Your Chat ID is 3089013.
Your question is, “Matthew?..conversation suddenly off”
(07:28:55 PM) System: There are currently 19 people in front of you and 78 chat technicians assisting customers.
(07:29:33 PM) System: There are currently 18 people in front of you and 79 chat technicians assisting customers.
(07:29:54 PM) Joel Hu: has entered the chat.
(07:29:55 PM) Joel Hu: Welcome to Hostgator Live Chat.
(07:29:57 PM) Henry: My previous Chat ID was 3088963.
(07:29:59 PM) Joel Hu: I will be happy to assist you with that.
(07:30:22 PM) Henry: I need to continue with Matthew
(07:30:41 PM) Joel Hu: Yep, trying to reach him
(07:30:47 PM) Henry: Thx
(07:31:26 PM) Matthew Je: has entered the chat.
(07:31:33 PM) Henry: Select option, now what
(07:31:40 PM) Henry: Hi again
(07:31:43 PM) Matthew Je: Hello again Henry!
(07:32:11 PM) Henry: My Window just updated my pc, it wants restart my PC..better quick
(07:32:24 PM) Matthew Je: Would you update the siteURL from http://bestleadsconversiontraffic.com to the temporary
URL. http://your.ip.add.ress/~cPanelUsername/addondomain.com
(07:32:24 PM) Henry: I postpone it
(07:32:42 PM) Matthew Je: I see Henry, those can be very inconvenient. If you can provide the current cPanel username I can provide the exact URL.
(07:32:49 PM) Henry: Under option, which should I select?
(07:34:07 PM) Henry: Nvm…I like to learn this and less ur burden…I can guide my friends if have this process ok
(07:34:36 PM) Matthew Je: You’ll update the option ‘SiteURL’ Henry.
(07:35:15 PM) Henry: Under browse or struture?
(07:35:44 PM) Matthew Je: Under browse.
(07:37:13 PM) Henry: https://gator1229.hostgator.com:2083/~fbcodes/bestleadsconversiontraffic.com
(07:37:17 PM) Henry: That correct?
(07:37:34 PM) Matthew Je: http://174.122.44.90/~fbcodes/bestleadsconversiontraffic.com would be the proper URL Henry.
(07:38:51 PM) Henry: “go” is means “enter” ..right?
(07:38:59 PM) Matthew Je: We’ll need to update the URL in one more please, “Home” on the next page. And yes Henry, that’s correct.
(07:39:35 PM) Henry: Ok ( The subdomain I do it after this one)…..home?
(07:39:54 PM) Henry: Back to previous DB? ..I got this wrong lo. Should be still the WP-Option. As time was consuming….I didn’t notice carefully of Mat guide.
(07:40:17 PM) Henry: What next?
(07:40:23 PM) Matthew Je: It’s under the same DB, on the next page.
(07:40:29 PM) Matthew Je: Have you updated both URLs Henry?
(07:40:41 PM) Henry: Yes, update
(07:41:36 PM) Henry: I can’t find next page?
(07:41:53 PM) Matthew Je: There’s a right arrow ‘ > ‘ at the bottom, select that to navigate to the next page.
(07:42:35 PM) Henry: I can see ” go” only
(07:42:50 PM) Matthew Je: You’ll need to hit “Go” to take you back to the Browse section.
(07:43:07 PM) Matthew Je: These are two separate additions.
(07:44:47 PM) Matthew Je: Were you able to locate option ID 37, “home” at this time?
(07:45:21 PM) Henry: The problem is I can’t locate the ‘>” button ( Message added next day: I should click the “go” button and it will land me at the page as what Mat mentioned. On this page, you can see ID37 and the ‘>” key. By clicking on it…it will show the temporary URL. )
(07:45:48 PM) Henry: Under bottom left or right…but there is no such “>” key
(07:46:06 PM) Matthew Je: While under the “Browse” section it will be both at the top and the bottom.
(07:46:20 PM) Matthew Je: There will also be a “Page Number:” drop down. You can select page 2 from there if you’d like.
(07:46:26 PM) Henry: Oh…I back to home DB..
(07:46:33 PM) Henry: Ok..back to browse
(07:47:36 PM) Matthew Je: Let me know once you’ve updated this second URL Henry.
(07:50:15 PM) Henry: Really..under browse, I can see option…check all/uncheck all
(07:50:31 PM) Henry: There’s no next key?
(07:51:03 PM) Matthew Je: It will simply be the character ‘ > ‘ and there will also be a “Page Number:” option. These are at the top and the bottom of the menu.
(07:51:08 PM) Matthew Je: Have you selected the ‘wp_options’ table?
(07:51:57 PM) Henry: Yes…I select browse under Wp-Option
(07:52:37 PM) Henry: Is this key <—|—->
(07:52:58 PM) Matthew Je: Would you select “Search” and under option_value enter: http://bestleadsconversiontraffic.com [ added message : This way also can get it done ]
(07:54:09 PM) Henry: ok
(07:54:16 PM) Henry: Click go now?
(07:54:24 PM) Matthew Je: Yes, you’ll update this option Henry.
(07:54:47 PM) Henry: Done
(07:55:12 PM) Henry: What next?
(07:55:34 PM) Matthew Je: The site should now pull up using the following URL: http://174.122.44.90/~fbcodes/bestleadsconversiontraffic.com [ Exactly ..beautiful! ]
(07:55:56 PM) Henry: U mean ..I can paste the link and see it works or not now?
(07:56:28 PM) Matthew Je: That is correct Henry.
(07:57:20 PM) Henry: It is loading…I am waiting to see
(07:57:59 PM) Matthew Je: I’m standing by Henry.
(07:59:08 PM) Henry: It is showing the page with 404 error?
(07:59:43 PM) Matthew Je: I see, was this going to be a static home page, or a list of posts?
(07:59:54 PM) Henry: Yes
(08:00:08 PM) Henry: The side bar and bottom is okay
(08:01:29 PM) Henry: I can reach here is good already with your guidance
(08:01:43 PM) Matthew Je: Wonderful, let me see if we can’t fix this 404 error Henry.
(08:01:43 PM) Henry: What is 404 error came from?
(08:02:26 PM) Henry: I should be the same like the permanent domain homepage?
(08:03:32 PM) Matthew Je: Are you able to log into your dashboard Henry?
(08:04:02 PM) Henry: You mean at HG …or my the other host?
(08:04:07 PM) Matthew Je: For the WordPress .
(08:05:03 PM) Henry: On HG host ?
(08:05:17 PM) Matthew Je: Yes, that’s correct Henry.
(08:05:21 PM) Henry: I can log in but other current host
(08:05:35 PM) Henry: Wait
(08:05:43 PM) Henry: Hmm…maybe they did it again
(08:05:56 PM) Henry: Sometimes, they ban my free account for nothing
(08:06:08 PM) Henry: The host is a reseller
(08:06:38 PM) Henry: That’s why I want to transfer to HG
(08:07:16 PM) Matthew Je: I see, I understand your frustration with that matter Henry. Are you not able to log into the WordPress dashboard with HostGator?
(08:08:28 PM) Henry: I am trying
(08:08:34 PM) Matthew Je: Take your time Henry.
(08:10:30 PM) Henry: The password should be correct but…it says incorrect..second attempts …I am in now
(08:10:56 PM) Henry: So…I can log in…
(08:11:42 PM) Matthew Je: What URL were you logging into Henry? I can verify you and update that password if you’d like.
(08:11:51 PM) Henry: Sure
(08:12:04 PM) Matthew Je: For security purposes, I will need you to verify your identity by providing the PayPal transaction ID of your most recent payment, or the last 4 digits of the credit card on file for the account, depending on your payment method.
I apologize for any inconvenience this may cause.
(08:12:08 PM) Henry: http://bestleadsconversiontraffic.com/wp-admin/
(08:12:44 PM) Henry: No problem..I am happy to learn some expertise skill from u and can help me more promoting HG later on
(08:13:05 PM) Matthew Je: You will need to use the temporary URL as this domain is not pointed to HostGator Henry.
(08:14:15 PM) Henry: That’s why I ask you HG. Ok..I try it now
(08:14:26 PM) Matthew Je: http://174.122.44.90/~fbcodes/bestleadsconversiontraffic.com/wp-admin
(08:18:13 PM) Matthew Je: Both payments listed have a PayPal Transaction ID.
(08:18:46 PM) Henry: I can log in to HG account or Paypal account
(08:19:05 PM) Henry: wait..let me check my file …
(08:19:31 PM) Matthew Je: Take your time. [ This is really patient guy ]
(08:21:48 PM) Henry: This is the invoice..hm..I got to log in my second paypal yahoo acount
(08:22:08 PM) Matthew Je: I do see it being listed as an @yahoo.com address. Let me know when you’ve located it.
(08:25:39 PM) Henry: I am waiting for the yahoo mail inbox loading..it loads the ads first…
(08:25:46 PM) Matthew Je: That’s fine, there’s no rush.
(08:27:09 PM) Henry: ID given and passed.
(08:28:01 PM) Matthew Je: One moment please.
After Matthew tried something but the error 404 still unable to get rid of. I suggested that I re-upload the domain files through FTP uploader. I prefer to use Filezilla. It is the most easier FTP uploader.
However, the next day, I have not done anything, I tried to visit the temporary URL and found out that I could not connect at all. To make sure I get back to Matthew, I just do the uploading first. After finished uploading and time passed by for some time, I then re-open the Gator chat.
Day-2
Your Chat ID is 3095363.
Your question is, “HI..”
(11:16:02 PM) System: There are currently 2 people in front of you and 81 chat technicians assisting customers.
(11:16:55 PM) System: There are currently 1 people in front of you and 81 chat technicians assisting customers.
(11:16:56 PM) Sarah Ca: has entered the chat.
(11:17:00 PM) Sarah Ca: Welcome to Hostgator Live Chat. My name is Sarah and I’ll be glad to help you.
(11:17:01 PM) Sarah Ca: How can I assist you?
(11:17:32 PM) Henry: Matthew Je there, our line cut off just now. [ Already have small chat with Matthew before this ]
(11:18:02 PM) Sarah Ca: Just a moment and I’ll check.
(11:18:08 PM) Henry: Thx
(11:19:43 PM) Matthew Je: has entered the chat.
(11:19:59 PM) Matthew Je: Welcome back Henry.
(11:20:03 PM) Henry: Sorry..screen hanged!
(11:20:10 PM) Henry: Can’t load
(11:20:32 PM) Matthew Je: I’m sitll receiving the 404 page Henry, do you have another theme we might try this with?
(11:20:59 PM) Henry: Oh..
(11:21:23 PM) Henry: I can change to default theme
(11:21:50 PM) Matthew Je: Surely, take your time Henry.
(11:22:59 PM) Henry: Default theme is twenty ten.activated
(11:23:09 PM) Matthew Je: Wonderful, testing it now Henry.
(11:23:53 PM) Matthew Je: So I’m seeing the following remnant in the code: <link rel=’index’ title=’Best Leads Conversion Traffic’ href=’http://bestleadsconversiontraffic.com’ /> Let me search the database perhaps it’s located there.
(11:24:42 PM) Henry: lo..how come?
(11:25:36 PM) Henry: I have a feeling that after I name the nameserver will solve the 404 error.
(11:26:04 PM) Matthew Je: Many times content added to wordpress will use the current URL Henry. http://174.122.44.90/~fbcodes/bestleadsconversiontraffic.com/ Would you test it for me now Henry?
(11:26:12 PM) Matthew Je: Try setting your original theme back for me as well please.
(11:27:00 PM) Henry: ha..it runs
(11:27:17 PM) Henry: OK..I set back to ori theme now
(11:27:27 PM) Matthew Je: Take your time Henry.
(11:28:15 PM) Henry: Ok..set…
(11:32:22 PM) Henry: It automatically switched back to home domain?
(11:32:34 PM) Matthew Je: It appears it was never updated properly. [ I discover that I have to get back into the Myphpadmin and activate using the same process as Matthew taught me and I managed to shoot the screen as you can see on below ]
(11:33:13 PM) Henry: Oh…just update it again…maybe I updated not properly by yesterday
(11:33:56 PM) Henry: Thx…just nice and about time I have to send something to my friend now
(11:34:05 PM) Matthew Je: Wonderful Henry, were you having issues with anything else for now?
(11:34:49 PM) Henry: No…you do very well…extreme excellent performance
(11:35:26 PM) Henry: Very nice talking to you and have an awesome day
(11:35:34 PM) Henry: Thank you very much
(11:35:37 PM) Matthew Je: Have an awesome day Henry! You’re very welcome .
(11:35:45 PM) Henry: Cheers!
(11:35:52 PM) Matthew Je: It’s been a pleasure!
(11:35:56 PM) Matthew Je: Thank you for using HostGator Live Chat. If you could take a minute to rate your experience with HostGator as well as my overall performance, that would help us to improve our customer service. To do that, just click the button that says Rate and Exit in the upper right hand corner. The survey takes less than a minute to fill out.
(11:36:00 PM) Henry: Rated and closed this chat intentionally
To update: If you are not sure how to get the temporary URL, get it from Live Chat Support.
To Find the arrow key:
Temporay URL: Something looks like this,
http://174.122.44.90/~fbcodes/yourdomain.com/
You can see my temporary URL on my Firefox browser.
Final Note: Login to your WP-admin, on Tools menu, click export and save into a safer place. This is the most important step for backing up all your important contents.
I hope you find this info useful for your process of transferring from other Word Press host to Hostgator or maybe other host of your own.
Pingback: What Hosting I Recommend, And Why Of My Chosen To Such An Hosting Company | Hosting recommendation