I have version 7.9 that was installed by another webmaster on another server. I want to move the existing installation and update to version 7.14. The problem is with the existing installation (7.9) when we save anything, it usually does not save. This is the reason I am updating the core and moving to another server as I feel there is either a bug or the current database has issues. This not saving of changes is sitewide and a major issue.

I have found the installation instructions and have found this post about moving an existing installation to a new server: http://drupal.org/node/1542156

But I could not find any documentation that talks about both. Since I am not that familiar with Drupal I though I would ask.

What I have already finished:
1. I backed up the complete site (files and databases) and have stored them on my computer.
2. I did a fresh core install of version 7.14 on the new server and created a new database.
3. I then uploaded the old database (saved from v7.9) into the new database I created. I did get some errors stating that some of the tables could not be created since they were duplicate. I assume the old database imported correctly. (I don't know if this was wise to do at this point)

What do I do now?
1. Do I need to import every module from the old installation directly into the new install?
2. Do I import these modules via the old files or go and install each one one-by-one?
3. How do I get the theme imported properly.
4. How do I import the old data (store, customers, consigners, products, and modules) into the new store?

I did not design this site, the original designer is out of the picture so I am trying to update core and install on new server for the client (and leave everything else as is). If someone could point me in the right direction it would be much appreciated.

Comments

leopardman’s picture

I was reading in another post and it was said: that any designer should back up all modified themes under the 'sites' folder. I have uploaded all the original files from the older server (originally created by other designer) under /sites to the new server. I am guessing now I will have the original template and modules loaded correctly onto the new site. By the way the modules were updated via the control panel before the migration so the modules should all be current.

VM’s picture

your step 3 is flawed making your assumption problematic

you don't install drupal, then import the database and while importing allow the duplicate tables to be dropped. Doing it this way means you are dropping tables that have data in them which the production site requires.

in a nut shell

create a new DB (if you use the already existing DB, drop all tables currently in the DB)
import the production site database
clear the cache tables
clear the sessions table
clear the watchdog table

move all files and folder to the new sever
open sites/default/settings.php
edit the DB string that connects to the old DB and switch that DB information to the point to the new DB

test site

leopardman’s picture

Thank you VM. Done exactly as you said and installation and migration are finished. I didn't want to delete the main tables in my database initially, but as you pointed out that was a mistake. When I dropped the tables the backup imported without a flaw.

VM’s picture

you're welcome. Good luck in your endeavors.

atulp88’s picture

donok’s picture

One thing that was catching me was that my new server liked to put prefixes on the database tables - make sure when you are importing the database over from the old server that you match the prefix' => in the settings.php file otherwise it just copies it alongside and you get two sets of drupal tables.