Jump to content
grintstick

Transferring site from MAMP local to live

Recommended Posts

grintstick    0
grintstick

Hi - I'm trying to transfer my site from working on it locally using MAMP to the live site. When I do this, following correct instructions (I think), the result is as you see it on www.minidynasty.com As you can see the site has not transferred properly - the site is fully working with images and so on on the MAMP site.

Are there extra things I need to do when transferring? Do I have to do anything with image tags and so on? Help much appreciated. Adam.

Share this post


Link to post
Share on other sites
batman    389
batman

Hi Adam

Your images are at folder

"YOUR SITE" / wp-contents/ uploads / 2012 / 09 (if you upload this month or 08 / 07 according the month)

You can try transfer it via FTP


Life is too short to remove USB safely ...

Share this post


Link to post
Share on other sites
catrina    103
catrina

batman is right. If the images are in the wrong directories (in this case, the wrong subdirectories because of the upload times), they're not going to work on the site.


Please read the docs before posting. Please do not private message me unless I ask you to.

Designer | Catrina Dulay

Founder | Catrina and Mouse

Share this post


Link to post
Share on other sites
grintstick    0
grintstick

Hi - thanks for the responses. Sorry for being slow here but if they are in the wrong directories due to the date problem, what would the correct directory be? Should I just take them out of the date directory entirely, or create a new directory? thanks...

Share this post


Link to post
Share on other sites
Simon    247
Simon

They are not in the wrong DIRs te links to them are wrong, click the link i posted above you will see your site url is in there twice.

Did you use some kind of database replacement tool?

Share this post


Link to post
Share on other sites
grintstick    0
grintstick

Hi Simon - thanks for your response. So should I change this in the settings within wordpress for each image? What should the correct URL's be? Perhaps you could point me towards some documentation on it if it exists? thanks...

Share this post


Link to post
Share on other sites
Simon    247
Simon

How did the images get the new urls?

Share this post


Link to post
Share on other sites
grintstick    0
grintstick

I see what you mean with the doubled up URL's. Not entirely sure how that's happened...

I followed this for transferring from MAMP:

http://www.slideshare.net/Miriam6142/from-local-to-live-exporting-wordpress-from-mamp

and also watched this:

and looked at the wordpress codex. What do you think is the way forward? thanks...

Share this post


Link to post
Share on other sites
Simon    247
Simon

Yea looks like you messed up the url replacement part, so 2 choices, repair each one, or start again ;)

Share this post


Link to post
Share on other sites
grintstick    0
grintstick

p.s. i think the images got the new URL's possibly by me using the find and replace tool in a text editor after I exported the SQL database from my offline site. So I changed the localhost URL's to the live ones using this tool... maybe it happened there... although I just looked at the SQL file and there's no doubling up in it. hmmmmm....

Share this post


Link to post
Share on other sites
grintstick    0
grintstick

ok thanks... although it seems odd that the doubling up is not happening in my SQL file which is where I do the URL replace, so if I do it again I think the file will remain the same... but I still get doubled up URL's on the images. Do you think it could be coming from somewhere else other than the SQL file?

Share this post


Link to post
Share on other sites
Simon    247
Simon

Marking this resolved for moderation purposes....

Basically your going to have to run the replace in the SQL again to fix those urls.

Share this post


Link to post
Share on other sites
Simon    247
Simon

The topic was marked as resolved.

Share this post


Link to post
Share on other sites
grintstick    0
grintstick

Simon -

I've managed to re-do the SQL file and am now at least getting some of the images coming up correctly. However, the formatting is all over the place and each page seems to be displaying elements that were hidden in my offline version. Various style things have not come across at all, like the colour of the background, fonts and so on, so just wonder how to fix this? URL is minidynasty.com.

Help appreciated...

Adam.

Share this post


Link to post
Share on other sites
Simon    247
Simon

Are you editing the SQL file before you import it?

Share this post


Link to post
Share on other sites
grintstick    0
grintstick

Yes, I'm changing the URL's from my localhost to my live URL, but that's it.

Share this post


Link to post
Share on other sites
Simon    247
Simon

Right well, that url will be stored in serialized data, are you taking that into account?

You cannot edit serialized data, it breaks it.

for example, it might show it as:


s:17:"http://banana.com";
[/CODE] then you change banana for apple
[CODE]
s:17:"http://apple.com";

PHP will now load that value as NULL because the string length is wrong!, should be 17 chars, see? You cant just edit serialized data.

Share this post


Link to post
Share on other sites
grintstick    0
grintstick

ok understood... but in that case how do I change the URL's in the SQL file to reflect my live domain. Looking at lots of tutorials this is exactly what it tells me to do. Any ideas how to get round this?

Share this post


Link to post
Share on other sites
Simon    247
Simon

You have 2 choices, use MAMP with virtual hosts, and then the urls will all be the same, locally and remote or import your SQL into remote then use a search and replace plugin to unserialize, edit then reserialize the data.

Share this post


Link to post
Share on other sites
grintstick    0
grintstick

Ah! A breakthrough! Yes the problem was because I was using a simple text editor to find and replace the local URL's with the live URL's. I ended up using the php script by Interconnectit.com

http://interconnectit.com/719/migrating-a-wordpresswpmubuddypress-website/

Blimey - someone should write a script which makes this thing a whole lot more user friendly - if Pagelines is supposed to be that they should put some time into writing a script that takes your site from local to live. Anyway, thanks a lot for your help - much appreciated.

Adam.

Share this post


Link to post
Share on other sites
Rob    547
Rob

Simon's solution is the best.

I'm marking this Resolved for moderation purposes.


Former PageLines Moderator, Food Expert and Raconteur

Share this post


Link to post
Share on other sites
Rob    547
Rob

The topic was marked as resolved.


Former PageLines Moderator, Food Expert and Raconteur

Share this post


Link to post
Share on other sites
grintstick    0
grintstick

Sorry this isn't quite resolved. It seems that changing the URL's in the SQL file is a bit of an inexact science when dealing with serialised strings. Using the interconnectit.com plugin, it worked once, but then failed to work again when I updated the site. I have re-exported the SQL file, reloaded all the WP content files several times over, tried Peach as well for another find and replace tools. The closest I have got is the full site but with missing widgets and broken links to pages. At the moment, I've just got a Pagelines logo. Check the URL and you'll see.

It seems something to do with the SQL DB but every route I try results in a broken site, each in a different way.

Any ideas?

Adam.

Share this post


Link to post
Share on other sites
Simon    247
Simon

The only way that really only works is MAMP and virtual hosts. Thats how I do it, Ive moved pagelines.com 3 times with that method ;)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Similar Content

    • PeriniNero
      By PeriniNero+
      Strange behaviour of websites (in both situations just the main website of a wordpress multisite install); the live version is totally different from the site you see when you login to dms to edit. See attachments. 2 examples are: http://pnmdemo.comand http://courtesypeople.com 
       
      The only thing we changed recently was upgrading php, apache and mysql versions.
       
      Do you have any idea what happened or what we can do to fix this?
       
      Thanks.
       
    • bloom1creative
      By bloom1creative+
      Hi
       
      Can somebody please tell me the correct method for moving the DMS from a subfolder WordPress install?  I have had this issue several times, the last instance I just added the folder after all the [pl_site_url] shortcodes which was a bit of a headache to say the least....
       
      This time I moved another install, and I have had this before, where the DMS editor no longer initiates when you visit the URL without the subfolder, so the RAW URL I mean.
       
      I have also lost the LESS, CSS, and header and footer sections that I had all designed and ready, and all I did was drag the .htaccess file outside the folder, add the index.php with the correct folder location to the root, and change the home url in the db.  I have no clue how that would cause the theme to behave in this way.
       
      I am incidentally using the Voyant child theme, which has already wiped all the settings on me once before.
       
      Thanks
       
      Rob
       
       
    • gabelloyd
      By gabelloyd
      I've Googled for the past hour on this, but I feel like this a really n00b question.  
       
      Background: This is not my first website, but first Pagelines.
      Platform:  WP 3.8
      Theme:  DMS
      Pagelines:  free
      Local setup:  MAMP, php 5.5.3
      Process of "loading files" on my local environment:  Drag theme folders into the "wp-content/themes" folder.  (this is how I work locally without problem, usually)
       
      Goal:  Install DMS Theme for a local working environment, add a child theme.
       
      I've downloaded the installed the DMS theme (free).  At first, I just loaded this to an existing project.  When I did not see the DMS in the Appearance> Themes area, I thought "Well, maybe the existing installation is conflicting with it?".  
       
      I loaded the site to a test server and I was able to load the theme using the "upload a .zip file" method (not loading the file using my FTP client directly into the themes folder).  This works.  Hm.
       
      I decided that I should try installing the DMS locally on a fresh install of WP.  Installed on a new database, new theme folder, again the DMS theme is not recognized.  Hm.  So, I loaded the base child theme I found on Github:  https://github.com/bearded-avenger/nicks-base-theme by copying these files into my themes folder, and THAT showed up (but of course is saying that it's parent theme 'dms' is not found).  
       
      I'm stumped.  Can I not drag theme folders into the 'wp-content/themes/' folder for local installation?  Did I miss something in the documentation about working locally?  
       
      Thanks for your help!
       
       
    • Olly
      By Olly
      I am running MAMP PRO for local development. After considerable headaches (see my other post!), I have setup a local development environment at a special local domain name: www.mysite-localdev.com:8888
       
      The live site is located at www.mysite.com
       
      My question is, how can I use the Pagelines store in my local environment? I obviosly don't want to activate the local devlopemnt site address (www.mysite-localdev.com:8888), only the live site address, but I can't use the live site locally. If I activate it, does that use up one of my six product activations? If so, how can I get access to the store when developing locally without activating?
       
      Is the only way to do this, to use the same address for the local development site, as the live site (pushed local via the HOSTS file)?
    • Olly
      By Olly
      I appreciate this question is not specifically about Pagelines itself, but I could really use some help with this.
       
      I have setup MAMP for doing Pagelines DMS local development on my MBPro running OSX Mavericks. However, when I come to try and install themes and plugins in the Wordpress back end it requests me for my FTP server information, saying: "To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host."
       
      Can any one tell me how to set this up?
       
      I tried following the instructions here: http://osxdaily.com/2011/09/29/start-an-ftp-or-sftp-server-in-mac-os-x-lion/
       
      I entered my hostname as 'localhost' and the username/password as my local account username and password. It doesn't work -  just says "Unable to locate WordPress Root directory."
       
      Is it possible to get this working, or does everything have to be done manually, by copying plugins etc. to the wp-content sub-folders.
×