By sirius60 on

Hi

We are moving our site from one host to another namely from a namesco server to a webhostingUK server. When the site was first set up this was done by an independent person, the data they have given to move the site is ftp access to all the files and a settings.php.

Previously I have managed to load a back up of our site on my local machine using a ftp back up and an sql dump of the database. It all worked reasonably well except that some of the content, images and youtube videos were missing and and the colours looked transparent.

I have never used a settings.php file for the the database before so I'm not sure what to do with it?

I have read several threads that give different bits of information but I have limited access to the files on the old server so if I don't get this done soon then I'm going to have some real problems.

I am a newbie at this but I am quite good at giving things a go (with help) and getting them to work so any help to do this task would be very much appreciated

⋅ Categories: Drupal 5.x

Comments

willhowlett’s picture

willhowlett commented

I'm no expert, but doing the following should help.

- Download the entire contents of the public_html folder of server you have been given the FTP details to (this assumes the Drupal installation is in the root of the server, otherwise download the contents of whatever subfolder it is installed in)

- In your webhostingUK Cpanel, under Databases, go to Myphp database wizard and create a new database plus a new user profile with full privilages. Make a note of the database name, password and the user name. (be aware that some providers add a prefix to the database name and username you provide, you can check the full names in 'MySQL databases' after creating them).

- Again under Databases go to PHPMyadmin. You should see the new database you have created on the left. Click on it and then click on 'Import' on the top. Navigate to the SQL dump you have been provided with and upload it. It should give you a confirmation message if no errors are encountered (I sometimes run into a few problems here, depending on a number of variables. Shout if you get any errors).

- In the folder you downloaded the Drupal install contents to navigate to sites -> default. You should see the settings.php file in here. Open the file with Notepad (or Notepad ++ if you want to make life easier for yourself - google it to download) and find the uncommented out line (i.e. line without an asterix in front of it) which starts $db_url. It will read something like $db_url = 'mysql://username:password@localhost/databasename';

- Change the username, password and database name areas in this line according to info you noted earlier. Save the file.

- Upload all the files you downloaded earlier via FTP to the public_html folder of your new host. The site should now work.

Hope that helps. Good luck!