MySQL Help needed - GoFuckYourself.com

Boobs · 10-23-2006, 09:55 PM

ok i have mysql backup from one of my blogs

i want to use this mysql backup on another domain so it's pretty much identical to the site that was backedup

one problem, when i import the mysql tables, the links on the categories, posts, etc. links to the original domain from which it came.

is there a way i can edit the domain so it'll link to the new domain that I imported the mysql tables to?

any help appreciated

teksonline · 10-23-2006, 09:56 PM

what version MySQL?

Boobs · 10-23-2006, 10:00 PM

MySQL - 5.0.18

teksonline · 10-23-2006, 10:08 PM

well doh what am i thinking, if you have a unix server do this

try this, (untested)
perl -pi.bak -e 's#http://www.domain.com#http://newdomain.com#g' file.sql

your sql dump file is just a text file, so if no unix, use any search,replace text editor

Boobs · 10-23-2006, 10:11 PM

im very illiterate at this, what am i suppose to do with that code

teksonline · 10-23-2006, 10:12 PM

now i know why I am hungry :/

Boobs · 10-23-2006, 10:16 PM

aha gotcha

Boobs · 10-23-2006, 10:17 PM

duh i can just search and replace

10-23-2006, 09:55 PM	#1
Boobs Confirmed User Join Date: Aug 2006 Posts: 7,875	MySQL Help needed ok i have mysql backup from one of my blogs i want to use this mysql backup on another domain so it's pretty much identical to the site that was backedup one problem, when i import the mysql tables, the links on the categories, posts, etc. links to the original domain from which it came. is there a way i can edit the domain so it'll link to the new domain that I imported the mysql tables to? any help appreciated __________________ Join the fucking best in big tit sponsors!!!

10-23-2006, 10:00 PM	#3
Boobs Confirmed User Join Date: Aug 2006 Posts: 7,875	MySQL - 5.0.18 __________________ Join the fucking best in big tit sponsors!!!

10-23-2006, 10:08 PM	#4
teksonline So Fucking Banned Join Date: Jan 2005 Location: At My Desk Posts: 2,904	well doh what am i thinking, if you have a unix server do this try this, (untested) perl -pi.bak -e 's#http://www.domain.com#http://newdomain.com#g' file.sql your sql dump file is just a text file, so if no unix, use any search,replace text editor Last edited by teksonline; 10-23-2006 at 10:10 PM..

10-23-2006, 10:11 PM	#5
Boobs Confirmed User Join Date: Aug 2006 Posts: 7,875	im very illiterate at this, what am i suppose to do with that code __________________ Join the fucking best in big tit sponsors!!!

10-23-2006, 10:16 PM	#7
Boobs Confirmed User Join Date: Aug 2006 Posts: 7,875	aha gotcha __________________ Join the fucking best in big tit sponsors!!!

10-23-2006, 09:56 PM	#2
teksonline So Fucking Banned Join Date: Jan 2005 Location: At My Desk Posts: 2,904	what version MySQL?

10-23-2006, 10:12 PM	#6
teksonline So Fucking Banned Join Date: Jan 2005 Location: At My Desk Posts: 2,904	now i know why I am hungry :/

10-23-2006, 10:17 PM	#8
Boobs Confirmed User Join Date: Aug 2006 Posts: 7,875	duh i can just search and replace __________________ Join the fucking best in big tit sponsors!!!