Export all procedures alone from mysql via terminal

May 11, 2013June 12, 2013 Sreejith PM Leave a comment

This is a easiest way to export all procedures alone from specified database through Terminal. Using mysqldump we can do this. General syntax of the command is as follows,



mysqldump -u [db username] -h [db server name] -p --routines --no-create-info --no-data --no-create-db --skip-opt [database name] > [path to the destination]/filename.sql

mysqldump -u [db username] -h [db server name] -p --routines --no-create-info --no-data --no-create-db --skip-opt [database name] > [path to the destination]/filename.sql

After enter the command in Terminal press ENTER, then the Terminal will prompt to enter database password where you have to provide the database password. Then you can check the path which you specified to save the .sql file. In the specified path you can see the export file.

Function to convert UNIX timestamp to GMT timestamp

May 9, 2013June 25, 2013 Sreejith PM Leave a comment

Here, I’m sharing two functions to convert the UNIX timestamp to GMT timestamp and vice versa using PHP predefined functions.



    /* Function to get GMT timestamp */
    function getGMTTimeStamp() {
        $time = date('d-m-Y H:i:s');
        $gmtTimeVal = gmdate('d-m-Y H:i:s', $time);
        $gmtTimeStamp = strtotime($gmtTimeVal);
        return $gmtTimeStamp;
    }

    /* Function to get the LOCALE timestamp/ UNIX timestamp from a GMT timestamp */
    function getLOCALTimeStamp($gmttimestamp) {

        $strGmtTime = date('d-m-Y H:i:s', $gmttimestamp);
        $arrDateDet = explode(" ", $strGmtTime);
        $strDateParts = $arrDateDet[0];
        $strTimeParts = $arrDateDet[1];

        $arrDateParts = explode("-", $strDateParts);
        $arrTimeParts = explode(":", $strTimeParts);

        $strLocalTimeForGmt = gmmktime($arrTimeParts[0], $arrTimeParts[1], 
$arrTimeParts[2], $arrDateParts[1], $arrDateParts[0], $arrDateParts[2]);

        return $strLocalTimeForGmt;
    }

/* Function to get GMT timestamp */

function getGMTTimeStamp() {

$time = date('d-m-Y H:i:s');

$gmtTimeVal = gmdate('d-m-Y H:i:s', $time);

$gmtTimeStamp = strtotime($gmtTimeVal);

return $gmtTimeStamp;

}

/* Function to get the LOCALE timestamp/ UNIX timestamp from a GMT timestamp */

function getLOCALTimeStamp($gmttimestamp) {

$strGmtTime = date('d-m-Y H:i:s', $gmttimestamp);

$arrDateDet = explode(" ", $strGmtTime);

$strDateParts = $arrDateDet[0];

$strTimeParts = $arrDateDet[1];

$arrDateParts = explode("-", $strDateParts);

$arrTimeParts = explode(":", $strTimeParts);

$strLocalTimeForGmt = gmmktime($arrTimeParts[0], $arrTimeParts[1],

$arrTimeParts[2], $arrDateParts[1], $arrDateParts[0], $arrDateParts[2]);

return $strLocalTimeForGmt;

}

Connecting mysql server via terminal

May 9, 2013June 12, 2013 Sreejith PM Leave a comment

We all know that there is GUI available to connect MYSQL server (phpmyadmin). Most of the developers are not aware about connecting MYSQL server via terminal. Here we are going to explain how to connect a MYSQL server (both local & remote) via terminal.



i) First open the Terminal.
ii) Type the following command to connect to the server, general syntax is

mysql -u  [db username] -h [db server name] -p

i) First open the Terminal.

ii) Type the following command to connect to the server, general syntax is

mysql -u [db username] -h [db server name] -p

After enter the above command, press ENTER. Then the Terminal will prompt to enter the password to connect. If you given valid credentials, then the terminal will display the shell pointer as mysql>

Once the connection established you can manipulate the database using SQL commands.