Transfering the dev site to the live site - files still point to dev site
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

=-=
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
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