tinasher

Thanks for your reply Andrea. I did that in all three sets of tables for options, blogs, site, and sitemeta. I will check that again.

Wouldn’t I at least have something other than an Internal Server Error page on my url if everything else was done right but that? Network Solutions tells me to wait for 2 hours after I redirected to the root directory but still no sign of my site.

Do you recommend that I do the search and replace in a text editor and then re-import again? I am afraid my phpMyAdmin skills might be the problem as I don’t know how to work with the dump file within phpMyAdmin.

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?
https://localhost/wordpress/
https://localhost/wordpress/site2
https://localhost/wordpress/site3
becomes:
https://mainsite.com/wordpress/
https://mainsite.com/wordpress/site2
https://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?

Hi,

This is my situation: WordPress 3.1.2 on a Mac. I am a visual designer with basic skills in coding but getting better as I work on this stuff.

I have a multisite WP installation running perfectly on localhost/wordpress with 2 subsites that are set up like this: localhost/wordpress/, localhost/wordpress/site2, localhost/wordpress/site3.

This will be my second time trying to move my multisite to an external host. I am starting clean and was wondering if someone who has done this can share any step-by-step directions to do this successfully. As I said, Multisite works fine locally. How do I move it to my new primary site url?

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.

Right, I have one database.

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

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

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

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?

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: https://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!