We have a hosted site that we need to take down and archive but before we turn it off on the hosting site we have these requirements and questions....thanks in advance if someone can give me some guidance.

Info: We have the Drupal web files backed up in a tar.gz file, a .sql database backup file and an apache.conf.backup file from the hosting company...they tell us these 3 files are our site. My assumption here is that this was on a Linux OS with Apache on the hosting site. We are a windows shop with IIS. Our management wants us to be able to stand up this site in house for access and archiving purposes. This raises these questions....

1) Can we take these 3 files and stand this up in IIS/Windows? If so, are there some detailed instructions on this process?
2) If question #1 is a NO, can it be done with Apache on a windows box? Or do these backups require it to be on Linux/Apache?

Please supply any answers/instructions/advise to make our goal here as easy as possible.

thanks!

Comments

eriksandall’s picture

1) You can use the tar.gz and .sql backups, but since you'll be using IIS instead of Apache as the webserver, the Apache config file won't be much use. You might need to install PHP and an SQL database -- I don't think those are installed by default on a Windows server.

2) Apache can be installed and run on Windows. This is commonly achieved by installing a software stack called WAMP (Windows, Apache, MySQL, PHP). I have used WampServer and am pleased with it. Going this route will let you use the 3 backup files your host provided.

dljohnson69’s picture

Much appreciate the info Erik....if we go the second route, do we have to install a blank database first and then use the .SQL backup file? Or does the WAMP stack install take care of that? Same question with PHP....does it need to be installed before the install of WAMP or will the WAMP install take care of that too? My apologies as we aren't familiar with this process or any dependencies....let me know if you are aware of any detailed instructions/checklists on this process.....

Thanks

Thanks

eriksandall’s picture

I think the best way to go about this is to start with a fresh install of Drupal on your new server, then upload your SQL and files as if you were restoring from a backup. So to answer your first question, yes, you will first need to create an empty database. Second, PHP will be installed with WAMP (that's what the 'P' stands for).

Here's a migration guide to help: https://www.drupal.org/node/776864

Here's a guide to a fresh install, if you decide to start there: https://www.drupal.org/docs/7/installing-drupal-7/step-1-download-and-ex...

Since your site is offline and you already have the files from your host, you're not going to be able to do some of the steps (such as disabling Clean URLs, if you were using that). So you might run into some snags along the way -- but if you do, feel free to post a new question to this forum.

dljohnson69’s picture

Thanks, that really helps. I went the route of the new install and used a Acquia Dev desktop that was referred from the site you supplied above. It seemed pretty cut and dried after the install and wanted the location of my current site files and database .SQL file. The tool seemed to load MySQL and Apache and had the green light on both. When I initially hit the URL it took quite a awhile to load but eventually errored, so I changed the PHP version from the default of 5.5.33 to the 7.0.4 (not sure which the site actually used as I didn't build it) and it got the error below...any ideas?

Error
The website encountered an unexpected error. Please try again later.
Error message
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal.semaphore' doesn't exist: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of C:\drupal\includes\lock.inc).
Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal.semaphore' doesn't exist: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 368540084588119fd87bb47.85750145 ) in lock_release_all() (line 269 of C:\drupal\includes\lock.inc).