Skip to main content

Posts

Showing posts from June, 2011

set up hotmail on ur ipod touch!

Hwy guys I figured a way to syuc ur hotmail on to ur ipod touch using WiFi Under Settings, tap on “Mail, Contacts, Calendar”. Then choose “Add Account”. Choose “Microsoft Exchange”. Fill all the details Server / URL m.hotmail.com Username Enter full email address, for example: myname@hotmail.com Domain Leave this blank SSL Enable this Certificate Accept the SSL certificate when prompted Click done. And ur DONE!

Reset ID Field in an mysql table (1,2,3,4…)

u need to use the following command in an mysql terminal. -- your_table: The table to modify -- id: The id field/column to reset SET @num := 0; UPDATE your_table SET id = @num := (@num+1); ALTER TABLE your_table AUTO_INCREMENT =1; (This code is taken from http://www.daftspunk.com/code/how-to-reset-table-id-fields-1234-using-mysql.html)

ubuntu multiple wallpaper 4r ur workspace

Disable the "show desktop" feature in Nautilus. The process to do that is 1. Press ALT+F2 2. type gconf-editor press enter 3. navigate to Apps --> Nautilus --> Preferences 4. Uncheck "show desktop". Part 2 1. Press ALT + F2 2. type CCSM 3. on the left click on Utility and then on wallpaper 4. select the same number of wallpapers as the number of workspaces. UR DONE :)

Importing Mysql file using Source Command

1. Create an empty database in phpMyadmin. Main thing to do is give it the same name as the sql file you are trying to upload. One can also use command CREATE DATABASE databasename; 2. Log on into shell: mysql -u root -p. It will then ask you for your root password. Type it in 3. Let Mysql know which file you intend to use mysql> USE file.sql;. (If you fail to use the USE command you can end up with this error: “error 1046 (3D0000): no database selected. If your database is large this error can freeze the screen) 4. Dump the sql data file with this code: SOURCE /home/username/foldername/file.sql. AND U R DONE.