WordPress.org

Ready to get started?Download WordPress

Forums

moving MU from localhost to VPS (19 posts)

  1. s0206
    Member
    Posted 3 years ago #

    Hi All

    I am having great difficulty trying to move my wordpress MU from my localhost to my VPS.

    I am currently trying to set the wp mu up on a tempory url until it has been apporoved by client I can then switch the domain over.

    I moved all the wp files and uploaded the DB but I get a blank screen. I am not sure I have entered the correct details in my htaccess and wpconfig file.

    My site is on a temp url made up of a Ip address and then a directory name which contains thie character ~

    I'm not sure what I should be putting as my blog url, is it the actual domain or this temp url?

    My hosts have been a complete nightmare!

    I'm so lost :-(

  2. Tim Moore
    Moderator
    Posted 3 years ago #

    Blank pages mean PHP errors, usually. Check your error logs for more.

    If you have the final domain name already, you should use that when installing MultiSite. A temporary URL can be hard to change (you need to do a search/replace in the entire DB to change it).

  3. s0206
    Member
    Posted 3 years ago #

    Thanks for your reply Tim and the advice. I didnt realise it would be problematic to change from temp url to the actual domain.

    I have got it up and running, not even sure what the exact problem was but I re-installed everything and 4 hours later I have something working.

    I do have the domain and there is a wp site running on there but it was single install not MU also I am setting the new site up on a new domain. I thought it might be easier to leave the old site where it is and install the new one on a temp url and then switch the domain.

    Is this a bad way to go about it? I don't want to set myself up for anymore major disasters.

    What would you suggest I do?

    Thanks again for your reply.

  4. Tim Moore
    Moderator
    Posted 3 years ago #

    If you have the domain name that MultiSite will run on in the end, I would use it. It'll save you headaches in the long run.

  5. s0206
    Member
    Posted 3 years ago #

    Thank you for the advice. I'm a bit stuck as to what I should do now.

    I have spent hours getting the site to work on the temp url, I'm worried if I try to do the process again something may go wrong.

    Do you think I should point the domain to the new server, place a holding page there whilst I try to get the new multisite working with the correct domain and not the temp url?

    Sorry for all the questions, this is my first time doing this.

    :-)

  6. Switching the domain in multisite is not that same as doing it in a single install - which people still have issues with. ;)

    in multisite, you have to go through the entire database (multiple tables and fields) as well as the confgi file and htaccess.

    If you put up a fresh install, you still need to enable the network as it is disabled by default.

  7. s0206
    Member
    Posted 3 years ago #

    Thanks for your reply Andrea.

    I have spent most of the day reading up on this and as you say it's not as straightforward as one may think.

    I'm at a loss as to what I should do. I currently have the multisite running on the temp url on the new server. Does it make sense to

    • switch the DNS to point to the new server
    • add a holding page here
    • Do a file/replace on the database to replace all instances of the temp url with the actual domain.
    • Make my changes in the htaccess and wpconfig
    • Test the links and put the site live

    The thought of going through the whole install process again makes me want to pull my hair out :-)

  8. Yes, that looks about right.

    Just before switching the DNS at the last minute, you can test it where only you can see it by messing with your hosts file.

    http://wpmututorials.com/how-to/using-a-hosts-file/

  9. s0206
    Member
    Posted 3 years ago #

    Thank you for the link Andrea, it was very helpful.

    Just one question though, as I already have the site setup on a temp url on the new server, if I was to use the method mentioned in the above link, would it be best to set the site up on my localhost test it all there and then transfer to the server and switch the DNS?

    (Hope that makes sense!)

  10. If when you set it up locally you use the final domain name and switch your hosts file, yes.

    Then *you* are the only one who sees it on the "live" domain, but the actual real live domain is untouched until you move everything over.

    And this way avoids you having to find & replace all the addresses in the db.

  11. tinasher
    Member
    Posted 2 years ago #

    All of these posts have been helpful but now I am stuck. I managed to import my WP multisite database and FTP'd all files from localhost to a Network Solutions hosted domain: http://www.tinasher.com). I did this to launch one of my sites and work on the others while hidden but it seems like the FTP and the database is not synching yet and I'm having three different problems:

    The themes are gone, just the content is there. Is it an FTP problem or a mysql file problem? Could the names of my sites be not matching?

    The directories are set now so site# is the root but I want site2 to be the root, the site I am launching. All the links on this page link to site#. How do I fix the sql file or the .htaccess file in phpMyAdmin? I'm on a Mac and have been using TextEdit to edit the config and sql files.

    Any help would be great!

  12. The themes are gone, just the content is there. Is it an FTP problem or a mysql file problem?

    What do you mean by gone? the page is unstyled?

    If so, that's an htaccess issue.

  13. tinasher
    Member
    Posted 2 years ago #

    I am still trying to move my multisite to external host. I'm reading all the codex info but still not getting the overview I need. I made my changes to all three options tables, blog dir and site url using phpMyAdmin replacing localhost with the appropriate domain. I made edits to my config file regarding Mysql database host name. For .htaccess I didn't know what to change. So that's the same as it was locally.

    Tell me if I understand the big picture....

    My multisite with 3 sites was working fine set up locally.
    I set up my 3 hosting packages connected to 3 domains to point to one htdocs/wordpress folder. I imported the database to one of the sites but it wasn't the main site. Could this be the problem? Should I only upload and import to the main site hosting?

  14. If you set up multisite locally with 3 sites, you shoul donly have one database.

    You have to go through the *entrie* db and put the main domain in there correctly.

    Do I have this right - your subsites are all different domains as well? how did you map them locally?

  15. tinasher
    Member
    Posted 2 years ago #

    Right, I have one database.

    Yes my subsites are all different domains. Locally the urls were like this:

    http://localhost/wordpress/mintdesign/ (main_)
    http://localhost/wordpress/tinasher/ (main_2)
    http://localhost/wordpress/sherstudios/ (main_3)

    Can you show me what you mean by put main domain in there correctly?

  16. tinasher
    Member
    Posted 2 years ago #

    Hi Andrea,
    I deleted the database that I had uploaded to site 2 and imported it to site 1, my main site. I changed the config file so it represents the new mysql host name. I reset permissions on all three sites from NS's FTP manager. I am getting an "under construction" message for the main site, an "error establishing a database connection" from the url where I had the database originally and an "access denied" for the other.

    Network Solutions gives this tip online for adding a database:
    Tips for using your database:
    You will get the best performance from your database if you use the server name in your scripts and code that calls it. If you need the IP address for a database, select it, click "Edit"'

    Where do the scripts and code call for a server name?
    Where does the IP address get added in the address? Do I replace localhost with IP address or server name? You mentioned putting the "main domain" in my db correctly. Are these all different things?

    Any help is apreciated.

  17. I deleted the database that I had uploaded to site 2 and imported it to site 1, my main site.

    So, are you even using multisite. the built in feature for multiple sites - or did you just do thee separate installs into one db?

  18. tinasher
    Member
    Posted 2 years ago #

    Thanks for replying! Didn't see your question. Still not moved yet and growing tired of this but determined to get this done!

    I am running Multi-Site (WP Network on 3.1.2) on a Mac. I have been reading all these forums and I am starting over on my goal of moving my multisite from localhost to an external shared host(Network Solutions) so all my sites will have the unique public domains that I just purchased. My questions about IP addresses I found answered in the domain mapping — I will add them with the Domain mapping plugin to my subsites after I get my Network's main site moved over. (please confirm that this is right).

    Before I try the move again (export db, import db, ftp wp files after I fix config file), should I change "host" at the top of the db (.sql) file before I import it from "localhost" to "mysqlv19" the server alias that gets generated in Network Solutions or is that not necessary?
    If so, in the rest of the database I was going to replace "localhost" with my main site domain. Does that seem right?
    http://localhost/wordpress/
    http://localhost/wordpress/site2
    http://localhost/wordpress/site3
    becomes:
    http://mainsite.com/wordpress/
    http://mainsite.com/wordpress/site2
    http://mainsite.com/wordpress/site3
    Is this right?
    Can I get rid of the /wordpress/ if I FTP the contents of my local "WordPress" folder to the root folder that my new host gives me?

  19. in the rest of the database I was going to replace "localhost" with my main site domain. Does that seem right?

    yes that's exactly what you do.

    Can I get rid of the /wordpress/ if I FTP the contents of my local "WordPress" folder to the root folder that my new host gives me?

    yes. otherwise domain mapping won't work.

Topic Closed

This topic has been closed to new replies.

About this Topic