To update WordPress options with the new domain location, use the following SQL command:
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' After that you will need to fix URLs of the WordPress posts and pages, which translated from post slug, and stored in database wp_posts table as guid field. The URL values in this field are stored as absolute URLs instead of relative URLs, so it needs to be changed with the following SQL query: UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com',' http://www.new-domain.com'); If you have linked internally within blog posts or pages with absolute URLs, these links will point to wrong locations after you move the blog location. Use the following SQL commands to fix all internal links to own blog in all WordPress posts and pages: UPDATE wp_posts SET post_content = replace(post_content, ' http://www.old-domain.com', 'http://www.new-domain.com'); On Thu, Jul 14, 2016 at 10:22 AM, Joseph John <[email protected]> wrote: > Thanks once again > everything seems fine now, except the home banner pages, when I check the > src , I could see some url links which is pointing to the old location, the > code I pasted here for reference.. > -------- > <link rel="shortcut icon" href=" > http://www.changeme.it/wp-content/uploads/2013/09/favicon.ico"; > type="image/x-icon"> > <link rel="apple-touch-icon" href=" > http://www.changeme.it/wp-content/uploads/2013/09/favicon.jpg";> > <link rel="apple-touch-icon" sizes="72x72" href=" > http://www.changeme.it/wp-content/uploads/2013/09/favicon1.jpg";> > <link rel="apple-touch-icon" sizes="114x114" href=" > http://www.changeme.it/wp-content/uploads/2013/09/favicon2.jpg";> > > > > <meta name='robots' content='noindex,follow' /> > <link rel="alternate" type="application/rss+xml" title="My Company » > Feed" href="http://www.changeme.it/?feed=rss2"; /> > <link rel="alternate" type="application/rss+xml" title="My Company » > Comments Feed" href="http://www.changeme.it/?feed=comments-rss2"; /> > <link rel="alternate" type="application/rss+xml" title="My Company » > homepage Comments Feed" href=" > http://www.changeme.it/?feed=rss2&page_id=1629"; /> > -------------- > Which table, I have to change to make the banner section show the image > Thanks > Joseph John > > > > On Thu, Jul 14, 2016 at 7:15 AM, Joseph John <[email protected]> wrote: > >> Thanks Bincy >> And thanks to Sreenadh for pointing me out the table "wp_posts " , it >> stores image url also >> No almost every thing is coming up, but the banner image on the middle >> takes infinitie time to show up >> thanks >> >> >> On Wed, Jul 13, 2016 at 4:33 PM, bincy mb <[email protected]> wrote: >> >>> Wp-Option : change siteurl >>> home :change siteurl >>> >>> >>> On Wed, Jul 13, 2016 at 5:39 PM, Joseph John <[email protected]> wrote: >>> >>>> need to edit the table wp_options >>>> SELECT * >>>> FROM `wp_options` >>>> >>>> >>>> On Wed, Jul 13, 2016 at 4:04 PM, Joseph John <[email protected]> >>>> wrote: >>>> >>>>> Dear All, >>>>> I am not a WP, proffesional >>>>> Recently I was trying to help one friend, I took the backup and >>>>> restored it in my localnetwork, >>>>> Once i restored WP in my local network, I am not able to parse the >>>>> url images, reason is that the source code shows the public ip address >>>>> url, >>>>> how could I change it in for my local instance >>>>> so that I can parse it >>>>> Guidance requested >>>>> thanks >>>>> Joseph John >>>>> >>>> >>>> -- >>>> -- >>>> "Freedom is the only law". >>>> "Freedom Unplugged" >>>> http://www.ilug-tvm.org >>>> >>>> You received this message because you are subscribed to the Google >>>> Groups "ilug-tvm" group. >>>> To control your subscription visit >>>> http://groups.google.co.in/group/ilug-tvm/subscribe >>>> To post to this group, send email to [email protected] >>>> To unsubscribe from this group, send email to >>>> [email protected] >>>> >>>> >>>> >>>> For details visit the google group page: >>>> http://groups.google.com/group/ilug-tvm?hl=en >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "Free Software Users Group, Thiruvananthapuram" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> [image: photo] >>> *BINCY MB* >>> CEO, Aletcodex Technologies >>> 0 9037 699 749 | [email protected] | www.aletcodex.com | Skype: >>> bincymb <https://webapp.wisestamp.com/#> | Cochin >>> >>> -- >>> -- >>> "Freedom is the only law". >>> "Freedom Unplugged" >>> http://www.ilug-tvm.org >>> >>> You received this message because you are subscribed to the Google >>> Groups "ilug-tvm" group. >>> To control your subscription visit >>> http://groups.google.co.in/group/ilug-tvm/subscribe >>> To post to this group, send email to [email protected] >>> To unsubscribe from this group, send email to >>> [email protected] >>> >>> >>> >>> For details visit the google group page: >>> http://groups.google.com/group/ilug-tvm?hl=en >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "Free Software Users Group, Thiruvananthapuram" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- > -- > "Freedom is the only law". > "Freedom Unplugged" > http://www.ilug-tvm.org > > You received this message because you are subscribed to the Google > Groups "ilug-tvm" group. > To control your subscription visit > http://groups.google.co.in/group/ilug-tvm/subscribe > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > > > > For details visit the google group page: > http://groups.google.com/group/ilug-tvm?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Free Software Users Group, Thiruvananthapuram" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- -- -- "Freedom is the only law". "Freedom Unplugged" http://www.ilug-tvm.org You received this message because you are subscribed to the Google Groups "ilug-tvm" group. To control your subscription visit http://groups.google.co.in/group/ilug-tvm/subscribe To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For details visit the google group page: http://groups.google.com/group/ilug-tvm?hl=en --- You received this message because you are subscribed to the Google Groups "Free Software Users Group, Thiruvananthapuram" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
![http://www.changeme.it/wp-content/uploads/2013/09/favicon.jpg"](http://www.changeme.it/wp-content/uploads/2013/09/favicon.jpg"){kind=link}
![http://www.changeme.it/wp-content/uploads/2013/09/favicon1.jpg"](http://www.changeme.it/wp-content/uploads/2013/09/favicon1.jpg"){kind=link}
![http://www.changeme.it/wp-content/uploads/2013/09/favicon2.jpg"](http://www.changeme.it/wp-content/uploads/2013/09/favicon2.jpg"){kind=link}