Trasnfering Wordpress Database

4 replies
  • WEB DESIGN
  • |
I'm incredibly frustrated at the moment so if I miss any details please let me know and I'll fill them in asap.

I just switched my hosting provider to godaddy. I have several websites with wordpress databases that I now need to transfer to this new host.

With my previous host, I had someone else managing it all for me so this is my first experience flying solo.

When I was signing up with godaddy I also bought a new domain. The domain was automatically added to the server. I think anything I want to put for that site is in the root directory (/).

I added another domain(bought with different provider, set the dns) through godaddys user interface. I think this is in /second-domain, and anything I want to add for that site goes in here.

So as the domain I registered was for an entirely new site I was able to installed a fresh wordpress on that easily with godaddy. However the second domain I added is for a website which I'm transferring from my previous host. With that in mind, I follow the steps on this page exactly: https://flippa.com/help/transfer-a-wordpress-site

However, I'm getting a 403 error:
"You don't have permission to access / on this server. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request."


Ok, so now here's what I think could be the cause of the problem:

Potential Problem One:
Based on the steps in the link above, when I uploaded the site content I uploaded it to /second-domain. However I uploaded it here in a compressed file and when I extracted, it had /second-domain/extracted-content. As the domain points (I think) to the /second-domain directory I'm not sure if it matters that all my website content is within another folder which is inside the /second-domain directory. I did however change the upload path in the wp_options table(?) to the correct path(second-domain/extracted-content/wp-content/uploads).

Thoughts?

Potential Problem Two:
This one is a bit simpler I think. When editing the wp_config file before uploading, I'm not 100% sure I put in the correct information. The name, username and password are definitely all fine but the "hostname" I'm not sure of. I put in the "Server" listed in the phpMyAdmin options within the godaddy UI. It was pretty long compared to the last one though. It's structured like "username.db.numerics.hostedresource.com". Maybe that's just the way godaddy do it though.

Lastly, I just realised now that in step 15 (link above) I didn't upload to "/public_html" as they show in the screenshot. Not sure if this matters.



I would really appreciate any help anyone can offer. I'm sure it's actually a simple and straightforward enough process, but I've been struggling. I've tried several different ways of importing the database so far and I've been unsuccessful then finally found the what I thought was comprehensive guide from flippa and still have had no luck.

Really would appreciate any advice or thoughts,
Thanks a lot,
Jason
#database #trasnfering #wordpress
  • Profile picture of the author Freddy Rodriguez
    I'll have to admit that I got a bit lost in your explanation of what you did. But...(correct me if I'm wrong), you have one domain on your main hosting account that you purchased through GoDaddy.

    Where I get lost is what you're trying to do with the second domain that you purchased. It sounds to me like you're trying to host two domains on the same hosting account. (correct me if I'm wrong).

    Covering both bases...if you're trying to use your GoDaddy domain as the main domain with Wordpress, and have the second domain point to the same hosting account but a different Wordpress installation, I would recommend setting up a subdomain (http://subdomain.maindomain.com) and then installing a Wordpress instance on the subdomain.

    As far as all of the editing of the wp-config.php file and going into the phpmyadmin...I don't think that is really necessary on GoDaddy. I believe they have what's called the Hosting Connection that lets you install Wordpress in a few clicks.

    In that case, migrating or moving your Wordpress from one server to another should be pretty simple. I would suggest the Wordpress Move plugin - WordPress › WordPress Move « WordPress Plugins

    I hope that helps.
    {{ DiscussionBoard.errors[5567442].message }}
  • Profile picture of the author aldemer
    base in my experienced in Godaddy hosting, the method your execute in first domain is ok but the second domain in which you have an error I think it is not ok, you need to point it first your second domain to the hosting before you can add in your hosting account. about your database problem you need to create a new database in your GD Hosting account, replace your WP config DB information to your new one and upload, import your database to your newly created database.
    I dont know if what GD hosting plan you have. but I am sure I can help you about this problem just drop me a message in skype
    {{ DiscussionBoard.errors[5567516].message }}
  • Profile picture of the author Irvan Mhd
    3 days ago I just moved my wp blog to another hosting of mine. I did it manually and it works now. I followed the instruction on this but I failed. So, I decided to use my own way and it works now.

    The steps are :
    1. Backup your wp database for PHP MyAdmin from your old hosting.
    2. Download all folders of your wp blog (all files and folder in /public_html
    3. Set the domain to the new nameserver form new host.
    4. Install new fresh wp blog with Fantastico
    5. Access wp-config.php file from your new fresh wp blog and write down the details of the database name, password, and db username.
    6. Open your old wp-config.php file (from your old wp blog files that has been downloaded) and change the details of the database. (from poin no.5).
    7. Upload all your old wp blog folder and files to your new wp blog directories. (wp admin folder, wp content, etc.)
    8. Then try to access your old blog in a new hosting.
    9. Done!

    Sorry, my english is bad. Hope you can understand the instruction above.
    Really, it works fine. I have tried it myself 3 days ago after searching the information for days and I failed.

    Thanks.
    {{ DiscussionBoard.errors[5567651].message }}
  • Profile picture of the author Jasonsc
    Thanks for the help. I've got it sorted. I won't explain what I was doing wrong or how I fixed it but if anyone happens to come across this thread they can feel free to pm me and I'll be happy to explain.
    {{ DiscussionBoard.errors[5573286].message }}

Trending Topics