importing mysql data dump via command line

Recently we had to import a db dump (.sql) file of size 346MB.

Yes there are tweaks to do the same via phpmyadmin to increase post limit, timeout time, upload size etc.

However doing it command line seemed like a better option

Here is the command to import the database

mysql -u your_user -p your_db_name < sql_filename.sql

This works irrespective of the dump size.

Cheers to command line!

Delete PHP from Ubuntu Installation

Below are the commands that will delete the default php installation from your system. The commands worked well with Ubuntu 12.04 LTS

bash -c "sudo apt-get remove php*"

sudo apt-get remove --purge php-pear php5-cli php5-common php5-curl php5-fpm php5-gd php5-intl php5-mysql php5-pspell php5-readline php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl

sudo aptitude remove ~iphp

Cheers!

Installing a specific version of Cordova

With the recent releases and compatibility issues with the plugins we have to switch to some particular version of Cordova/Phonegap which works stable for our exisiting projects. However I was having issue in finding the exact version no to which I need to re-install.

Using command line we can see the versions of cordova available by

npm view cordova versions

The output is like :

C:\Users\upasana>npm view cordova versions

[ '0.0.0-fake',
'0.0.1',
'0.0.2',
'0.0.3',
'0.0.4',
'0.0.5',
'0.0.6',
'0.0.7',
'0.0.8',
'0.0.9',
'0.1.0',
..............
..............
'4.0.0',
'4.0.1',
'4.1.0',
'4.1.1',
'4.1.2',
'4.1.3-nightly.2014.10.21',
'4.2.0',
'4.3.0',
'4.3.1',
'5.0.0',
'5.1.1' ]

 

Then to install a particular version we use the following command.

npm install -g cordova@4.2.0

Have a great day!