Import local wordpress files

Asked by:
bgrenon / 8 Points
Time:
2013-01-08 11:46 pm EST
Category:
Wordpress
Hits:
385
Hi there -- I tried to migrate a local wordpress (mamp on mac) to my new web hub server area, following these instructions:
http://www.webhostinghub.com/support/edu/wordpress/wordpress-migrate

It seemed to work ok, except using filezilla I wasn't really sure where I was transferring files to.

Anyway, I check my domain amberhyoung.com, and only getting the web hub default page. I did not install wordpress, the instructions made it sound like copying wordpress files over would be enough

Any advice?

Thanks!
Barry

To ask this user for more information, please first login.

To submit an answer, please login.

Best answer chosen by User

0

JacobN
Staff
2,247 Points
2013-01-09 1:22 am EST
Hello Barry, and thank you for your question.

It looks like we might need to update the education channel you mentioned to be a bit more specific, I read over it and it doesn't mention where exactly on the server to place your files.

Basically the document root of your website, which is the directory that files will be pulled from by default when just entering in your domain name, is going to be /public_html/. So as an example if you had a file called myfile.htm and you wanted it accessible from amberhyoung.com/myfile.htm, the /public_html/ directory is where you'd want to upload it to.

It looks like you put your WordPress files inside /public_html/admin/, so WordPress would have been accessible for you from amberhyoung.com/admin. I've gone ahead and moved these files for you into just /public_html/ so you just need to enter in the domain name to get the WordPress site pulled up.

Even after making that change though it wasn't working, as it looked like inside your wp-config.php file you had the DB_HOST set to localhost:8889 which might have been the port that MySQL ran on your own server. On our servers you just need localhost as MySQL runs on the default MySQL port.

It also looked like in your WordPress database itself, you had over 500 instances of http://localhost:8888/wordpress spread over your various tables leading to further issues on our server. I loaded up phpMyAdmin on your account, and used the SQL tab to run the following SQL statements to correct all that:


update wp_options set option_value = replace(option_value,'http://localhost:8888/wordpress','http://amberhyoung.com');

update wp_postmeta set meta_Value = replace (meta_value,'http://localhost:8888/wordpress','http://amberhyoung.com');

update wp_posts set post_content = replace (post_content,'http://localhost:8888/wordpress','http://amberhyoung.com');

update wp_posts set guid = replace (guid,'http://localhost:8888/wordpress','http://amberhyoung.com');



In the future, if you're going to be developing any further WordPress sites locally, I'd recommend possibly taking a look at updating your hosts file on your Mac. That way you could use your domain name without having it pointed to a web server on the Internet yet.

You could have the domain name point to 127.0.0.1 which is the same as localhost. That way all of your WordPress settings can just use the domain name itself, then when you go to transition it onto the Internet you wouldn't need to change anything other than uploading the files to your /public_html/ directory, and uploading your MySQL database.

The WordPress site should be accessible now, and I don't think I missed anything. But take a look and let us know if you're still having any further issues.

- Jacob

To submit a comment on this answer, please first login.

Want to share this Question?

News / Announcements

Update to SSL Certificates - Certificate Warnings
1969-12-31 11:00 am EST
Hits: 696

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.