We needed to protect our production site from prying eyes for a while with a basic authentication. Using apache basic auth settings seemed not enough. Or actually was too much. We wanted the theme to blend in. So these files were not supposed to get protected. Only our Drupal pages should.
I want a clean database without clicking.
echo "\
SELECT concat('drop table ', table_name, ';') \
FROM information_schema.tables \
WHERE table_schema=schema()" \
| `drush sql-connect` \
| grep "^drop table " \
| `drush sql-connect`This work only for single drupal / single schema installs.
With drupal we can enable the locale module and install the i18n module to internationalise and translate our site we can make our hands dirty by visiting the http://build2be.com/admin/build/translate/search.
Still our work is not finished yet. We have to dive into settings.php to translate more strings of our site.
Taken from http://drupal.org/node/275705#comment-1058360 and using http://drupal.org/projects/drush_sm we learn we may choose from a lot of variables.
This book is about what step I took to prepare the (temporary) demo site and what my presentation is about.
Trying best practices I occasionally move the files directory from DRUPAL_ROOT/files/my-site.com to DRUPAL_ROOT/sites/my-sites/files
Doing this has some implications for the files table content. All file-path are pointing to the wrong location.
Quick solution for this is an mysql replace update query.
select replace(filepath, 'files/my-site/', 'sites/my-site/files/') from files;
# update files set filepath=replace(filepath, 'files/my-site/', 'sites/my-site/files/')"Or through drush
These are my notes when doing my first (drupal) presentation @ FrOSCon 2008 Drupal Room
This method uses the concepts
This way an upgrade to another drupal version runs smoothly. Hmmm this was about developer environment.
Why do I need this? To make sites like http://nf.test http://nf.dev or http://froscon.demo
sudo su -
echo 127.0.0.254 froscon.demo >> /etc/hosts
It's quite neat using drush to install ubercart. Here is what I did.
Preparation
Installing
When making these images about modules i use graphviz to render them. But just ran into http://drupal.org/project/hypergraph which looks great.
So I have to study this one!
Commands to render a .dot file are ie with non overlapping nodes
neato -Goverlap=false -o my.neato.png -T png my.dot
or for a top down graph.
dot -T png -o my.dot.png my.dot
The attached image is an installation with the jstools, cck, views, drush, og in order to get faster user experiences.
Installing modules with drush is easy.
# drush pm install ubercart
My drush patch for a module manager makes it more easier to SEE what's installed.
listing# drush mm list
imagary# drush mm dot | dot -T png -o ~/graph.png
shows a module in error. (I deleted workflow_ng) scroll to the right for red