By genfoch01 on

Hello,

this is drupal 6

so my site needs to be moved from mysite.com to othersite.com
I understand i need to update the base url in settings.php
and update htaccess

but the site has MANY pages with links to the site url. changing those by hand would be very hard.
I was thinking about doing a database dump and using sed to change all mysite.com to othersite.com and then restoring the database from the altered dump file. would this work or do modules store some config data outside the DB? or is there simply a better way to go about this?

Thanks,
GF

⋅ Categories: Drupal 6.x

Comments

arulraj.m’s picture

arulraj.m commented

Hi,

For a single table update in Mysql:

 UPDATE `table_name` SET `field_name` = replace(field_name, 'mysite.com', 'othersite.com');

From multiple tables:
If you want to edit from all tables, best way is to take the dump and then find/replace and upload it back.