Import database to mysql throught console in windows

In this example, import ‘data.sql’ file into ‘blog’ database using vivek as username:
$ mysql -u vivek -p -h localhost blog < data.sql

If you have a dedicated database server, replace localhost hostname with with actual server name or IP address as follows:
$ mysql -u username -p -h 202.54.1.10 databasename < data.sql
OR use hostname such as mysql.cyberciti.biz
$ mysql -u username -p -h mysql.cyberciti.biz database-name < data.sql

If you do not know the database name or database name is included in sql dump you can try out something as follows:
$ mysql -u username -p -h 202.54.1.10 < data.sql

you may remove the host and add the database and table like the following

$ mysql -u username -p < data.sql

To make symbolic link to Dropbox ( sublime configuration )

If you have many plugins and sniipets you want them any way you, you have to sync them using dropbox

For linux ( mac also ) :


ln -sfF ~/Dropbox/Application\ Settings/Sublime\ Text\ 2/Packages/ ~/Library/Application\ Support/Sublime\ Text\ 2/Packages

For windows :


mklink /D “C:\Users\Max\AppData\Roaming\Sublime Text 2\Packages” “C:\Users\Max\Dropbox\Application Settings\Sublime Text 2\Packages"

Windows Commands

Sometime you may want to take a sneak look for windows command to make something :

here is a link for that :
http://ss64.com/nt/