Drupal to Drupal
Boz - June 12, 2009 - 15:52
I have a live drupal site which I want to use as a template for another site, so my basic question is how to get an exact copy of the live site on my pc's localhost to work on it?
I have installed Acquia Drupal which allows Multiple site to be worked on, I'd need to bring over the database also.
Many thanks in advance..
Boz
=-=
acquia drupal is no different than drupal where it concerns this desire. The only real difference in an acquia drupal installation is that it ships with contrib modules and drupal core from drupal.org does not.
the process:
set site in offline mode
clear watchdog, sessions and all cache tables (makes DB export file smaller and ensure no users are interacting with the database during export)
import the export in a database on your local machine
open settings.php and change $db_url to point to the new database, and if using $base_url alter if needed
pull all files and folders from live site
put on your local machine
visit your site, login and test.
If you intend to let the production site run, you can set it back online after the database export.
Thank you so much for your
Thank you so much for your advice, I'm very new to Drupal so please forgive my lack of knowledge.
I seem to be having porblem importing the existing database into phpmyadmin...I think its too large?
I'm wondering if there is anyone who could help me with this or do it for me?
Many thanks
Boz
=-=
you need to be more descriptive about your "problem"
if you are sure it is too large, take multiple exports of teh database one table at a time or a few tables at a time, use a script like big dump or adjust default server settings if necessary. Though I am not prepared to recommend those settings. phpmyadmin community may be more fruitful.
The database is 19.4mb with
The database is 19.4mb with 109 tables...I've tried bigdump but I think its my lack of knowledge thats causing the problem to be truthful and not the program itself as this is my first time working with phpmyadin etc.
Many thanks for your advice
Boz
=-=
your best bet is to watch video casts of upgrading drupal where they walk through the backup process.
unless you explain what your lack of knowledge is with a something like big dump, im not sure how to help.
I will try and find
I will try and find some...once again I appreciate the advice ;-)
Boz
I have a live drupal site
Install a package like Xampp (See http://drupal.org/node/481750 - or a search in the forums may lead to better instructions) or WAMP (I'm not conversant with this, though several forum users like/prefer it), download all drupal files, probably into a folder & in case you use Xampp, place it in the "htdocs" directory.
Export a copy of your online DB to your PC.
Go to http://localhost/phpmyadmin & create a database, for example with the exact name + db.username + db.password as that online. If the DB host is "localhost" set it to be that.
Import the DB tables to your newly created DB.
Go to htdocs => yourdrupalfolder => sites => default/ settings.php & see to it that the DB info corresponds to that in the database & if not adjust it accordingly.
Under normal circumstances, your site should be accessible at http://localhost/yourdrupalfolder
Acquia Drupal comes with
Acquia Drupal comes with phpmyadmin so I'm assuming that should be ok?
When I am eventually successful at getting this site onto my local pc, is it possible to rename the database etc to reflect the new site as it will be used as a template for an entirely new drupal site?
Many thanks
Boz
=-=
acquia drupal comes with phpmyadmin?
Yes phpmyadmin is provided on
Yes phpmyadmin is provided on my host for the live site and Acquia Drupal installs it on you local machine too.
Many thanks
Boz
=-=
ahh, they have a stack installer. Didn't realize that was put together.
Yes, it seems very good, just
Yes, it seems very good, just trying to get my head around how it works in terms of using it for multi sites ;-)
Multi-site installer
Hi Boz,
The current versions of the Acquia Drupal Stack Installer come with a multi-site installer to make it easy to install multiple sites in your stack. There is also some pretty good documentation on backing up and migrating sites in the Acquia Drupal documentation section of Acquia.com.
Josh
--
Blog: Adding Understanding | Work: Acquia
--
Blog: Joshua Brauer dot com | Drupal Support: Acquia
Hi Josh Thank you for the
Hi Josh
Thank you for the link but I couldnt find any info on migrating existing sites into Acquia Drupal but then again its porbaly me not having the knowledge required to fully understand...
Boz