MySQL replace

No Comments

Při převodu wordpressu z jedné domény na druhou jsem narazil na nutnost upravit položky v databázi, tento jednoduchý SQL příkaz by mohl ještě někomu pomoci:

UPDATE `wp_posts` SET 
`post_content`=REPLACE(`post_content`, 'STARA_DOMENA', 'NOVA_DOMENA')

Repository on FreeBSD 9.1

No Comments

On FreeBSD servers didn’t exist packages-9.1-release directory.

freebsd# pkg_add -r vim
Error: Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-9.1-release/Latest/vim.tbz: File unavailable (e.g., file not found, no access)
pkg_add: unable to fetch 'ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-9.1-release/Latest/vim.tbz' by URL
pkg_add: 1 package addition(s) failed

So, if you want install by pkg_add, you must set PACKAGESITE.

freebsd# setenv PACKAGESITE ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-9-current/Latest/
freebsd# setenv PACKAGESITE ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-9-current/Latest/
freebsd# export PACKAGESITE="ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-9-current/Latest/"
freebsd# export PACKAGESITE="ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-9-current/Latest/"

powered by EndomondoWP