Monthly Archives: March 2009

OpenWorld Continues

As is typical for me, the Monday of OpenWorld was the busiest. Now that it’s over, I can relax a bit. Yesterday was an action-packed day, so let’s hit the highlights. Roll the tape.
Our official session “Web 2.0 Technologies In the Enterprise: Lessons Learned, Tips, and Tricks from Oracle AppsLab” went pretty well. I’m not […]

Oracle Blogger Meetup and Oracle Ace Dinner Photos

In the past couple of days, I attended two special events. Here are the photos from the Oracle blogger meetup (Mohan has more here), and here are the ones from the Oracle Ace dinner.
I know that you want to put names on the faces. So, if you see yourself in any of the pictures, please […]

Problem transferring a mysql database with rsync

A little more then a year ago I wrote a post presenting three different methods to transfer a mysql database. The third method suggested in that post was copying the mysql database files directly from one server ( or location ) to another. This involved locking the tables with a read lock or even shutting […]

Introducerea datelor in Mysql cu php

Introducerea datelor in Mysql cu php, acesta este cel de-al treilea tutorial video, in care puteti invata cum se introduc informatiile in mysql folosind php
Imi cer scuze, dar sunt foarte bolnav , daca aveti intrebari, sau nu ati inteles ceva, lasa-ti un comentariu` si vom incerca sa rezolvam solutia.Fisierele create in tutorial se […]

User age in MySQL

Finally I have decided how to get the real age of users using mysql:

SELECT YEAR(NOW()) - YEAR(birthday) - IF ( MONTH(NOW())

Any comments?

Executing PL/SQL from ANT - how to get the output

Javaddicts and the Amis blog are reporting about executing pl/sql statements from Ant: Executing Oracle PL/SQL from Ant, Executing PL/SQL from ANT - how to keep the format straight.
I’ve also written an Ant target for my current project where we execute pl/sql. The pl/sql queries domain values from some tables and outputs an xml document […]

MySQLTuner 0.9.8 is now available

MySQLTuner 0.9.8 is now available for download and it is full of new changes! So far, MySQLTuner has been downloaded almost 24,000 times. Thanks for making it so popular.
Easy download!
You can download it simply by running wget mysqltuner.pl. You will automatically be redirected to the script.
Access servers remotely
If you have multiple servers […]