Backup MySQL with PostgresQL

May 23, 2009

Following the acquisition of MySQL by Oracle, I have been thinking what would Oracle do with MySQL?

(1) Will Oracle release MySQL as a Lighter version of Oracle?
(2) Will Oracle shelf MySQL and just compel all the users to use Oracle? That would be bad…
(3)  Will Oracle make MySQL – use after payment?

Lot of questions! So, I was thinking I should have an alternative for MySQL. Only option I have in Open Source Free Databases is PostgresQL. You know what I did -

I downloaded PostgresQL and played with it. I didn’t see much difference in usage, however there are experts who will be able to appreciate the difference in terms of performance etc., I am not that guy!:)


How to migrate Drupal instance, metadata and content?

May 22, 2009

As you know I had a blog in blogger migrated to Drupal, if you have read in one of my previous posts.

Now, I have a need to transfer drupal from one server to another server. It was very simple to do that.

I just copied the existing Drupal folder and placed it in the target Tomcat instance.

I used mysqldump.exe to create a drupal.sql in my source system. Then ran the drupal.sql in the target MySQL. Now, everything is set and Drupal is moved/copied to another location.

By the way mysqldump.exe is available in your MySQL instance directory.

Just do: mysqldump -u username -p password <databasename> drupal.sql

you are good to go!