dimitris kalamaras

mathematics, social network analysis, free software…

Category: Web development (Page 2 of 2)

Παιχνίδια, να περνάς την ώρα σου…

Πως σκοτώνεις την ώρα σου; Με παιχνίδια! 650+ παιχνίδια σε ένα WordPress. Και ανεβαίνουν κι άλλα! Τσεκάρετε http://www.paixnidia-paixnidia.gr/ και λειώστε…

Παιχνίδια !

Εκατοντάδες παιχνίδια για να σκοτώσεις την ώρα σου :)

Read More

Drush most useful commands for Drupal admins

After years wasting time on drupal/sql backups, drupal restores, drupal updates etc, I started using the powerful drush command.

If you don’t know it “drush” is simply a (dru)pal (sh)ell written in PHP. It has been developed by core drupal developers to assist sysadmin and developers in everyday site management.

First, to install drush in a typical Debian/Ubuntu server, you need to install the PHP Extension and Application Repository (PEAR) which hosts drush. Simply type:

Read More

How to replace a given string inside a mysql table?

Just use the fabulous command REPLACE provided by mysql. The syntax goes like this:

update database_table set table_column = replace (table_column, "oldstring", "newstring");

For instance, to replace all occurrences of “modules” inside the linuxformat.gr drupal db with “sites/all/modules” I typed in:

update linuxformat_system set filename = replace (filename, "modules", "sites/all/modules");

Page 2 of 2

Creative Commons License
Licensed under a Creative Commons Attribution-ShareAlike 4.0 International License - Powered by Linux