Upgrade mysql 5.5 to 5.6 ubuntu 14.04

Standard

step 1 : take a backup

mysqldump –lock-all-tables -u root -p –all-databases > dump.sql

step 2 : remove old mysql

sudo apt-get remove mysql-server
sudo apt-get autoremove

step 3 : install new version of mysql

sudo apt-get install mysql-client-5.6 mysql-client-core-5.6

sudo apt-get install mysql-server-5.6

step 4 : restore your data

mysql -u root -p < dump.sql

Install PINTA On UBUNTU

Standard

Installing Pinta

Pinta can be installed on Linux, Mac, Windows, or *BSD. Due to this, there are multiple ways to install Pinta based on what you are using as your operating system.

This document will show you the multiple ways to install Pinta.

Installing Pinta on Ubuntu

Install Pinta from default Ubuntu repository

Pinta is available in default Ubuntu repository. You can install it using:

  • Click on Ubuntu Software Center from Launcher (left site icon panel).
  • At the top right input box type in: Pinta and press Enter.
  • Pinta is displayed in list bellow. Click on it and click the Install button.

Continue reading

Install mysql Workbench

Standard

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.

The simplest way to install it in Ubuntu or Linux Mint is via Olivier Berten’s Miscellaneous PPA:

sudo add-apt-repository ppa:olivier-berten/misc
sudo apt-get update
sudo apt-get install mysql-workbench

workbench01

Depending on the Ubuntu version you are installing on, MySQL Workbench version will be between 5.2 and 6.0. For example, using this PPA I installed MySQL 5.2 on Ubuntu 12.04 and 6.0 on Ubuntu 13.10.

workbench02-1024x709

workbench03-1024x744

Redirect requests using .htaccess and mod_rewrite

Standard
  1. Make sure Apache .htaccess is enabled (by default it is enabled in Ubuntu)
  2. Make sure the Apache module mod_rewrite is enabled. Execute:

sudo a2enmod rewrite

..and see if rewrite is listed here:

sudo apache2ctl -M

and then you can redirect requests using RewriteRules. Example:

RewriteEngine On

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?_REQUEST=$1 [L]


=====
Check your apache.conf

<Directory /var/www/html/>
 Options Indexes FollowSymLinks 
 AllowOverride All
 Require all granted
 </Directory>

Install skype on ubuntu 14

Standard

It is Important if you installed older version of Skype on your Ubuntu, Clear the old Skype folder before installing latest version. Then clear that by using:

rm -rf ~/.Skype

Step 2: Preparing to Installing Skype.

  • Users of 64-bit Ubuntu, should enable MultiArch if it isn’t already enabled by running the command
    sudo dpkg --add-architecture i386
    
  • Update repositories and “updates” list:
    sudo apt-get update
    sudo apt-get install gdebi #(read Why you need to install gdebi...)
    

Step 3: Installing Skype

Method 1: Download and install from file

wget download.skype.com/linux/skype-ubuntu-precise_4.3.0.37-1_i386.deb
sudo gdebi skype-ubuntu-precise_4.3.0.37-1_i386.deb

Method 2: Install Skype from Canonical Partner Repository

So add the Canonical Partner Repository to “updates” list by following the command:

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

Then install Skype via the Software-Center or via the Terminal.

sudo apt-get update && sudo apt-get install skype

 

Install pakage .deb

Standard

Debian (.deb) packages are the packages that are used in Ubuntu. You can install any .deb package in your system. .deb files can generally be installed from your file manager (Nautilus) merely by clicking on them, since file associations with the default installer is already set in Ubuntu. These instructions are for those who wish to install packages from the command-line terminal (Terminal).

To install a downloaded Debian (Ubuntu) package (.deb): Open Terminal and type

sudo dpkg -i packagename.deb

To remove a Debian (Ubuntu) package (.deb):

sudo dpkg -r packagename

To Reconfigure/Repair an installed Debian (Ubuntu) package (.deb):

sudo dpkg-reconfigure packagename