Remove objects from Amazon S3 with Zend framework

Let us have look on to remove the objects which are stored in Amazon S3. If we have stored the object as <S3 bucket name> / <object name1> / <object name2 with some extension> . Actually <object name2> is coming under <object name1>. See below to get the code for removing the objects.

 

Read More

Function to convert UNIX timestamp to GMT timestamp

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

 

Read More

Connecting mysql server via terminal

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.

 

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.

Read More

Allow remote connections to mysql server

Here, we are going to discuss about allowing remote connections to our local MYSQL server. To do this just edit the MYSQL server configuration file my.cnf which you can found in /etc/mysql/my.cnf (Ubuntu 12.04). Check for the configuration variable called bind-address. Just comment that line by using # and then restart the MYSQL server. These steps you can do via Terminal. See below for more details:

i) Open your terminal

ii) Type sudo gedit  /etc/mysql/my.cnf and hit the ENTER

iii) Comment the bind-address line as discussed above

iv) Restart MYSQL server by typing the command sudo /etc/init.d/mysql restart. Hit the ENTER.

Once you have completed the above steps, check the remote connection to the MYSQL server.

Read More

Skype installation in Ubuntu12.04

Here we can see the Skype installation steps through the terminal in Ubuntu 12.04. Follow the steps given below:

i) Open the Terminal

ii) sudo add-apt-repository “deb http://archive.canonical.com/ $(lsb_release -sc) partner”

iii) sudo apt-get update

iv) sudo apt-get install skype

v) sudo apt-get -f install

that’s all, enjoy all the features provided by the Skype

Read More