I have a friend who has a Drupal site that is on a host server. She would like me to make some modifications to it. I'm just learning Drupal and figured I could export the database from the host site (and all files) and then set up a test site on my MacPro. I have already used MAMP to set up a couple of test sites and they work fine. This is however the first time trying to copy an existing site to move into my localhosting setup.
So here is what I did. First, in MAMP created a new database for the new test site (using the name of the online database name). Then exported the database with all the tables using phpMYAdmin from host server to my computer. Also downloaded all the site files and put them into a new directory in the httpdocs folder (\shavilan). Then tried to see if I could see anything. First got Drupal message that the site was down. Then read where I should edit the settings.php.file to use my localhost name and password. Now if I try to access the page there is just a blank page, as I assume I have no database files. So, then went into MAMP and phpMYAdmin and tried to import the database file that I downloaded. Whenever I try to import it, I get the following error message:
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 10, 2009 at 10:13 AM
