You don't have problems here. SQL is plain text, so you can simply do a find/replace. But do test thouroughly before you go online and keep a backup etc.

B2evo uses the $baseurl to be able to use relative paths. If you start using them also a move to a new server becomes even easier than this.

Good luck

Thanks! I'll have a go.

don't quote me, but I believe you can do something like :

update T_items__item set item_content = replace( 'http://old.domain.com/', 'http://new.domain.com/' ) where 1

¥

*edit*
Correction, it should look like this :

update T_items__item set item_content =  (replace( item_content, 'http://old.domain.com/', 'http://new.domain.com/' ) )

Cheers ¥åßßå - that sounds even better. Uploading a 24Mb database is a pain unless there's a good reason! I assume this is a SQL query?

it is, if you run it in PhpMyAdmin or similar then change the "T_" to "evo_" or whatever your table prefix is ;)

Ohh yeah, and take a backup of your backup before you run it .... just in case ;)

¥

Thanks - and yes I will backup. I've already got a nice collection of these backups building up into a pile on my desktop. A few more won't hur...
:)

Easiest way to take a backup is to create a new db and copy the tables across, no 26meg down/up to do ;) ( or use ssh and dump tables to a file on your server )

..... and it'd save yer desktop a fair amount of strain ;)

¥

100% success, thanks Yabba and Afwas. That sure beats a manual trawl. Actually, it was post_content, not item_content. But I managed to sort that out myself. Cheers.

yay, chalk another one up for the wetter side of the pond ;)

¥