http://www.twelvedozen.co.uk Just another WordPress weblog Thu, 04 Mar 2010 07:18:39 +0000 http://backend.userland.com/rss092 en Remove (Not Verified) - http://drupal.org/node/99409 Remove Submitted By - http://www.kirkdesigns.co.uk/format-submitted-text-drupal-6-nodes-and-comments Add Comments Header - http://drupal.org/node/76716 http://www.twelvedozen.co.uk/2010/03/drupal-format-comments/ Good file permissions tutorial - http://www.interspire.com/content/articles/12/1/FTP-and-Understanding-File-Permissions FTP overwrite problems using Virtualmin setup - http://www.virtualmin.com/node/9885 http://www.twelvedozen.co.uk/2010/01/file-permisions/ Linux to the rescue. This sure beats using Export from PhpMyAdmin, it can be slow and may time out with large databases. mysqldump -a -u USER -p DBNAME > /path/to/backupname.sql http://www.metatitan.com/mysql/6/how-to-backup-and-restore-large-databases-in-mysql.html http://www.twelvedozen.co.uk/2010/01/backing-up-large-mysql-database/ Check your SSL certificate - http://www.digicert.com/help/ Setting up SSL on apache: http://onlamp.com/pub/a/onlamp/2008/03/04/step-by-step-configuring-ssl-under-apache.html http://www.twelvedozen.co.uk/2010/01/setting-up-ssl-on-your-server/ If you need a slideshow for your Drupal website, I recommend using JCarousel Lite - http://gmarwaha.com/jquery/jcarousellite/ It has lots of parameters to tweak depending on how you want to set it up. It's easy to get working. One slight issue (well major issue really until I fixed it), that I had using ... http://www.twelvedozen.co.uk/2010/01/jquery-slide-show-for-drupal/ FILES="test.xml" # for loop read each file for f in $FILES do INF="$f" OUTF="$f.out.tmp" # replace javascript sed '//d;//d' $INF > $OUTF /bin/cp $OUTF $INF /bin/rm -f $OUTF done http://en.kioskea.net/faq/sujet-1451-sed-delete-one-or-more-lines-from-a-file http://www.oracle.com/technology/pub/articles/dulaney_sed.html http://www.twelvedozen.co.uk/2010/01/removing-text-from-file-using-shell/ In my quest to convert a CSV file to XML I've found the best advice seems to be to use Perl. Do I have Perl installed on my linux server? http://www.cyberciti.biz/faq/how-do-i-find-out-what-perl-modules-already-installed-on-my-system/ Enter the following command in shell - $ instmodsh To find the version of perl - http://www.cyberciti.biz/faq/how-can-i-find-out-perl-version/ $ perl -v Here's my findings: I've been following a tutorial ... http://www.twelvedozen.co.uk/2009/12/convert-csv-to-xml-using-perl/ Recently, I've changed the way I've been creating websites in Drupal. Instead of trying to make everything as easily as possible for clients to add content to their websites I'm actually more inclined to think that this can make creating sites more complicated. I know there are a plethora of ... http://www.twelvedozen.co.uk/2009/12/audio-player-for-drupal/ Hoults Yard is not the only supplier of such space...there are more suppliers of deskspace including http://space.carrotmedialtd.com. hedgehoglab.com offering desk space http://www.twelvedozen.co.uk/2009/12/developing-unconventional-offices%e2%80%8f/ Find the size of a directory du -sh /dir How to remove files older than 60 days find * -mtime +60 -exec rm -R {} \; http://www.twelvedozen.co.uk/2009/11/shell-commands/