The Forgettful Website Developer

moving wordpress site

After copying files and db content:

1. Edit wp-config.php with new db content
2. edit .htaccess (if parent folder name of wp has changed)
3. using phpMyAdmin (as instructioned in the above link)…
4. update all absolute URLs to new domain eg.
   UPDATE wp_options SET option_value = replace(option_value, ‘http://www.old-domain.com’, ‘http://www.new-domain.com’) WHERE option_name = ‘home’ OR option_name = ’siteurl’;
5. UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');
6. UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');

Some good webpages out there:

My slight different process/follow up includes:

• before uploading SQL content:
• find/replace in sql export:

• ’ with \‘

  “ with “

  ” with “

  – with -

  (else question marks show up in my article via)

• for some reason <sitename>/administrator doesn’t work anymore but <sitename>/administrator/index.php does

• beginning with
• copy Joomla site to new host (includes mysql export and file backup)
• tutorials
• visual tutorials

Getting started

• using templates
• beginners (what’s in the core, SEO)
• quickstart
• convert existing site to Joomla
• sections and categories - what’s the diff?
  • seo, section (like a book section) , category (like a book chapter), article (book page)
  • lots of good info on right also
• what are the steps?
• add modules before section/category?
• how do keywords fit in all this?

Moving a dev site to live

• going live
• moving Joomla 1.5 host to another Move - ensure owner has write access on configuration.php
  • chown - requires linux on own machine (unpack tar, chown, repack, then upload) - else you’ll need web host to unpack it on the server, chown it themselves
  • log_path, tmp_path, db stuff

Google search:

• Joomla “building a website”

Good results, some very good blogs

http://www.squidoo.com/building-a-joomla-website

http://www.compassdesigns.net/joomla-blog/Chicago-Joomla-EXPO-Presentation-Building-a-Successful-Website-with-Joomla-1.5.html

http://www.buildajoomlawebsite.com/freebies/Frontend.html

http://www.website-doityourself.com/

http://www.compassdesigns.net/tutorials.html

http://www.myjoomlacast.com

After a few months of figuring out how to do this myself. I liken this question to “Which car should I buy?” Theres so many to choose from and it will depend on what you are looking for. Here are some questions to get you going:

• Do I want to choose my own host, or go with theirs? (web host vs really easy-5 mins to get going)
• Do I want to sell stuff? (ecommerce)
• Do I know HTML or can I type content WYSIWYG (CMS)
• Do I need lots of extra features or at least add-able features? (plugins, extensions, modules, etc)
• Do I want my website to be written only by me or collaborative? (blogs, wikis)
• Do I want to post regularily on my site? eg time-based, events (blogs)
• Do I want to pay 0, little or a lot for it? (open source, ok with advertising, build myself, and/or someone else build for you)
• Do I live in the US? sometimes on some tools are available only to websites/people in the status (eg. MS Small Business Sharepoint)

For the purposes of my describing my research: I wanted:

• to choose my own host (I have better control over my domain name)
• WYSIWYG for easy changes later on by my clients (and quick for me too!)
• some extra plugins (eg. photo gallery, login, event registration,
• people to use a credit card
• to post regularily
• to pay little for tools - if there was a free version of there to do the trick - why not?
• I didn’t live in the US.

Google search tip

• search for the features you want. The product name that comes up the most can indicate where to go next