Hi Rachel

This is a well documented problem. Here are some notes that I wrote for myself when I had to do this

Having created a blank Drupal install on the live server I did the following:

1.    Ensured all the modules I was going to need were in sites/all/modules of the live server (likewise themes)
2.    Copied over the contents of sites/mywebsite to the live server
3.    Ensured the sites/mywebsite/files/ folder and subdirectories are writeable by the web server.
4.    Ensured the iform/client_helpers/cache and iform/clinet_helpers/uploade folders are writeable.
5.    Used the BackUp & Migrate module to download my database from the test server
6.    Enabled BackUp & Migrate module on the live server and used it to upload the database from step 4.
7.    In Drupal Site Configuration > File System, correct the File system path
8.    In MySql run a query like UPDATE files SET filepath = REPLACE(filepath, 'original_url', 'new_url');
9.    Had to edit a block to update links to images
10.    Had to edit theme settings to update link to custom logo

All the snags I had to fix in 8, 9 and 10 were due to the presence of absolute urls in the database which I could possibly have avoided if I had been more careful when creating the site.

Jim Bacon

Hi Jim
Many thanks for this information. I've tried it this afternoon and now have a nearly functioning website on the new server. The only hitch is that it is not reading in information from the warehouse - records and usernames and emails which I have set to read in on the recording pages if someone is logged in.
Do you know how I can fix that?
Also, I will need to connect to the live BRC Warehouse at somepoint soon I guess!
Many thanks
Rachel

Sorry my last message was not very clear at all!

Regarding the email addresses and usernames, I thought that as I was using the Easy Login module, these details were stored on the Warehouse. I've set for these to be automatically filled in on the recording form, but at the moment all I see is {email}, for example.

Regarding the records, when I go to my Explore Records page which I've built using the Dynamic Reporter Explorer form there are no records visible on the map or in the grid of records.

Both of these issues led me to think there was a problem with the website retrieving information from the warehouse. I've submitted records to the website on the new server and these records are present in the Warehouse. Also, when I run the iForm Diagnostics it says that it is connected to the Warehouse. So it seems to be a problem with the website getting information from the Warehouse.

Sorry, hope this makes a bit more sense this time!

Rachel