SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Evangelist snecz's Avatar
    Join Date
    Mar 2007
    Location
    Warsaw, Poland
    Posts
    429
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    XAMPP and importing database into server

    Hi,
    Because it's easier for me to work locally I've just started to use XAMPP for preparing sites in Wordpress locally and then moving them into server.
    My question is: What should I pay attention at? Will it be so easy: export database in XAMPP and import into server?
    Warsaw - the city that survived its own death.
    EMM8 - Profesjonalne Strony Internetowe
    Projektowanie Stron WWW

  2. #2
    doing my best to help c2uk's Avatar
    Join Date
    May 2005
    Location
    Cardiff
    Posts
    1,832
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There are a couple of Wordpress settings which tell Wordpress the URL, so you have to change those manually once imported to your actual server.

  3. #3
    SitePoint Evangelist snecz's Avatar
    Join Date
    Mar 2007
    Location
    Warsaw, Poland
    Posts
    429
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks c2uk.
    So I only have to pay attention at wp-config.php?
    Warsaw - the city that survived its own death.
    EMM8 - Profesjonalne Strony Internetowe
    Projektowanie Stron WWW

  4. #4
    doing my best to help c2uk's Avatar
    Join Date
    May 2005
    Location
    Cardiff
    Posts
    1,832
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    sorry, I was referring to settings in the database, but probably there as well - it's been a while since I used Wordpress

  5. #5
    Original Gangster silver trophy Thing's Avatar
    Join Date
    Oct 2000
    Location
    Philadelphia, PA
    Posts
    4,708
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    What c2uk is referring to is two values in the wp_options table, siteurl and home. If you change the domain of your WordPress website you need to update these values with a query like so:

    Code:
    UPDATE wp_options SET option_value = 'http://newdomain.com' WHERE option_name='siteurl' OR option_name = 'home';
    Also check out this article if you haven't already:
    http://www.jestro.com/convert-local-...nto-live-site/

  6. #6
    SitePoint Evangelist snecz's Avatar
    Join Date
    Mar 2007
    Location
    Warsaw, Poland
    Posts
    429
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the information and great link
    Warsaw - the city that survived its own death.
    EMM8 - Profesjonalne Strony Internetowe
    Projektowanie Stron WWW


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •