Skip to content
October 10, 2025
  • Use Personal Access Token for Github
  • Windows Equivalent of Linux ‘tail’ Command
  • Linux Mint: How to Activate Night Light
  • Portainer: How to Fix “Unable to retrieve image details”

Colek Colek

writing for living

Newsletter
Random News
  • Home
  • Donate
  • Contact
Headlines
  • Use Personal Access Token for Github

    9 months ago9 months ago
  • Windows Equivalent of Linux ‘tail’ Command

    1 year ago1 year ago
  • Linux Mint: How to Activate Night Light

    1 year ago1 year ago
  • Portainer: How to Fix “Unable to retrieve image details”

    1 year ago1 year ago
  • Ubuntu: How to Troubleshoot High CPU in MySQL

    2 years ago1 year ago
  • MySQL: How to Count Duplicated Records

    3 years ago3 years ago
  • Home
  • 2011
  • December
  • 13

December 13, 2011

mysql replace
  • SQL
  • Wordpress

How to Replace Old Domain URL in wp_posts Table

kumkum14 years ago9 years ago21 mins mins

I migrated my WordPress website to new domain, so I need to update all image URLs in wp_posts, wp_postmeta, and wp_options table which are still pointing to old domain. These are the SQL syntaxs to update the tables:

Read More

CATEGORIES

  • Android
  • Coldfusion
  • Container
  • Database
  • Debian
  • Docker
  • FreeBSD
  • Git
  • HTML
  • Internet
  • Javascript
  • Linux
  • MacOS
  • MySQL
  • Networking
  • Open Source
  • PHP
  • Programming
  • Security
  • Smartphone
  • SQL
  • Tips and Tricks
  • Trading
  • Tutorial
  • Ubuntu
  • Windows
  • Wireless
  • Wordpress
  • Yii2

Subscribe

Blogroll

  • Inti Delta Ekaprana
  • PT ARBI
  • Stem Cell Assays

Tags

backup bandwidth monitor bandwidth speed container debian dmg2iso docker excerpt get first image github google analytics highcpu imageantialias() insert using select JpGraph linux mint mysql network speed nighlight personalaccesstoken php php-mcrypt different version phpfox portainer powershell redshift root rsync samsung galaxy S III screen SetAntiAliasing shell script sql sql server 2005 squeeze ssh tail timezone token top twitter uptime windowstail wordpress
Newsmatic - News WordPress Theme 2025. Powered By BlazeThemes.