Open Source (FOSS)

Update your Drupal to the latest version: 6.26 or 7.15

Submitted by phil on Sun, 09/09/2012 - 13:51

If, like me, you were busy before the summer and disconnected for a few weeks, you will notice that now that things are getting back to normal (kids back in school, vacations are over), you have tons of things to do at work and at home. In addition, to everything else, it also means updating all your devices’ OS versions with patches, your software applications and, of course, your own web based applications.

For Drupal, don’t forget to update your version:

Bookmark/Search this post with

VirtualBox 4.1.22 out and ready to download

Submitted by phil on Sun, 09/09/2012 - 07:48

In case you missed the reminder Smile

Bookmark/Search this post with

VirtualBox 4.1.20 out and ready to download

Submitted by phil on Mon, 08/27/2012 - 20:05

In case you missed the reminder Smile

Bookmark/Search this post with

How to add a prefix to tables in a MySQL Schema?

Submitted by phil on Thu, 06/28/2012 - 12:38

I have recently had to change a database from one schema to another. Unfortunately, I have also had to change the prefix to bring some order in the tables in that specific destination schema.

In order to add a prefix to a set of tables within an existing schema, you will need to perform a few simply MySQL operations calling the ALTER and RENAME functions

In your MySQL editor (MySQL GUI Admin Tools, Workbench or PhpMyAdmin), type the following in the SQL script window:

Change urprefix and urDBName in the code below

SET group_concat_max_len=100000;

SELECT GROUP_CONCAT(CONCAT("ALTER TABLE ", table_name, " RENAME TO urprefix_", table_name) SEPARATOR ";") 
FROM information_schema.tables 
WHERE table_schema = "urDBName";

Bookmark/Search this post with