Transfering the dev site to the live site - files still point to dev site

staino83 - June 1, 2008 - 05:04

I am using drupal multisite for my drupal sites.
I have the following problems with drupal multisite setup:

* I create all new sites using a testing account first - for example i have created ibake.debosoft.com.au as the dev site for ibakesoftware.com.au
* I setup all sites to use a database prefix for the on drupal database - not a new database for each site
* When testing and construction is complete, i want to migrate the multisite to the live site (still using multisite setup)
* When doing this, the live site stills wants to access files such as pictures from the test site

Here is an example:
ibake setup on test site as multisite setup
/drupal/sites/ibake.debosoft.com.au
settings.php database settings are:
$db_url = 'mysqli://*****_drupal:*******@localhost/*****_drupal';
$db_prefix = 'ibakedev';

I am now happy with the test site and want to migrate site to live site. I have tried simply changing the ibake.debosoft.com.au dir to ibakesoftware.com.au
Doing this did not work....as the site still wants to access files from ibake.debosoft.com.au

I thought then i could just migrate the data from the drupal(ibakedev prefix) database to a new prefix. But looking through some of the SQL, it seems that files are directly hardcoded to point to ibake.debosoft.com.au/files

What is the best way to migrate from the test site to the live site - without retaining any of the test site references? (I plan to delete the dev sites)

Regards
Sam

=-=

VeryMisunderstood - June 1, 2008 - 05:46

how are the images attached to the nodes in question ? with a contrib.module ? or did you hardcode them yourself ?
have you double checked your $base_url in settings.php ?
cleared cache tables in DB ? before/after the move ?

you may have to manually edit the nodes. or you can do a find replace on the db to alter these paths depending on the previous question to you.

I don't add content to sites before they are launched because of these types of situations, especially stuff that gets added to the files folder.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )

images attached to node via IMCE - FCKeditor

staino83 - June 1, 2008 - 08:18

The images attached were added to the page using IMCE(via FCKeditor)

My base URL is commented out in the settings.php file. Should i set my base URL in settings.php? I think that when adding the image using FCKeditor - IMCE module - it has set the path in the database.

I didnt clear cache before the move....is this recommended?

What is your process when making development site? You said you dont add content? So you manually re-add the content to the live site?

Regards
Sam

 
 

Drupal is a registered trademark of Dries Buytaert.