My Google Shared Things:
http://www.google.com/s2/sharing/stuff?user=102365031743900677693

Installing AIR 1.5 on 64-bit Ubuntu 7.10 and 8.04

To install AIR 1.5 on Ubuntu 7.10 and 8.0, you must manually install the 32-bit files by following these directions:

1. Install the 32-bit binary files using the getlibs utility, which is available here: http://www.boundlesssupremacy.com/Cappy/getlibs/getlibs-all.deb. This utility helps you install 32-bit applications on 64-bit systems by downloading and installing the required libraries.
2. To use getlibs to install the AIR 1.5 libraries, enter the following command on the terminal:
   
   sudo getlibs ./AdobeAIRInstaller.bin
   
   The following packages are installed: lib32asound2, lib32gcc1, lib32ncurses5, lib32stdc++6, lib32z1, libc6, and libc6-i386.
   
3. Next, you need to install the 32-bit versions of libnns and libnspr, which are available here:
   
   • libnss3:
     http://mirrors.kernel.org/ubuntu/pool/main/n/nss/libnss3-1d_3.12.0~beta3-0ubuntu1_i386.deb
   • libnspr4:
     http://mirrors.kernel.org/ubuntu/pool/main/n/nspr/libnspr4-0d_4.7.1~beta2-0ubuntu1_i386.deb
4. You now need to open the packages you just downloaded by running file-roller as root so you can extract them to your /usr/lib32 folder. Begin by extracting the files in libnss, using the following command:
   
   sudo file-roller ./libnss3-1d_3.12.0~beta3-0ubuntu1_i386.deb
   
5. Double-click the data.tar.gz file. If the data.tar.gz file doesn't automatically open in file-roller, you may be asked which application to open it with. If you are prompted to choose the application, enter file-roller in the Application box and click Open.
6. In file-roller, locate and select the following files in the ./usr/lib folder:
   
   • libnss3.so.1d
   • libnssutil3.so.1d
   • libsmime3.so.1d
   • libssl3.so.1d
7. Click Extract. Click the top left button in this window. The button's icon is an image of a pencil and paper. If you hover your mouse over the button it will display "Type a file name" in a popup tooltip. Once the button has been clicked, a Location box will appear. Type /usr/lib32 in the Location box and click Extract.
8. Close all file-roller windows.
9. Extract the files in libnspr, using the following command:
   
   sudo file-roller ./libnspr4-0d_4.7.1~beta2-0ubuntu1_i386.deb
   
10. Double-click the data.tar.gz file and open with file-roller and then locate and select the following files in the ./usr/lib folder:
    
    • libnspr4.so.0d
    • libplc4.so.0d
    • libplds4.so.0d
11. Follow the same instructions as above (in step 7) to extract the files to the /usr/lib32 folder.
12. Finally, close file-roller and enter the following commands:
    
    sudo ln -s /usr/lib32/libnss3.so.1d /usr/lib32/libnss3.so

sudo ln -s /usr/lib32/libssl3.so.1d /usr/lib32/libssl3.so

sudo ln -s /usr/lib32/libnspr4.so.0d /usr/lib32/libnspr4.so
    
13. You are now ready to install Adobe AIR Linux. Type the following command:
    
    ./AdobeAIRIntaller.bin
    
    Adobe AIR is now installed on your system.
    
14. Just one more step before you start installing and using AIR apps. Enter the following command:
    
    sudo cp /usr/lib/libadobecertstore.so /usr/lib32

You're now ready to install and run AIR applications.

Move a database from MySQL to SQLite

Export from phpMyAdmin as either ANSI or TRADITIONAL compatability?, no extended inserts

use sqlite database browser to import the sql file from phpMyAdmin

If needed in sqlite 2, convert from sqlite 3 by: sqlite3 dbase.sqlite .dump | sqlite dbase_new.sqlite

Essential Firefox Extensions

• Adblock Plus
• Adblock Plus Element Hiding Helper
• Stylish (see user styles below)
• Firebug
• Foxmarks
• Download Statusbar
• DownThemAll!
• FireGestures/MouseGestures
• Faviconize Tab
• Hide Menubar
  
• Glassier (if you're running vista, link) (save this file, rename from .zip to .xpi and drag into add-ons window)
  
• Tabs Open Relative
  

Essential User Styles for use with Stylish

• Nicer about:blank - http://userstyles.org/styles/2329
• Combine stop/reload buttons - http://userstyles.org/styles/10
  
• autohide statusbar icons - http://userstyles.org/styles/5875
• New Gmail Native Attachment Icons - http://userstyles.org/styles/5545
• New Gmail Cleaner Theme (remove ads, hover highlighting, etc) - http://userstyles.org/styles/7542

 Essential Software

• Firefox
• Notepad++
• VirtualWin
• CygWin
• CCCP w/Media Player Classic
• AbiWord
• FileZilla
• AutoHotkey
• GIMP
• Pidgin or look into Carrier (funpidgin)
  
• Twhirl
• Windows Live Photo Gallery
  

Nice Software

• Windows Live Writer
• Rainlander
• RK Launcher
• Visual Studio 2008 Express Edition
  
• Evernote
  

Edit the path on linux

On Linux, edit your ~/.bash_profile or ~/.bashrc file. Look for a line that sets the PATH environment variable and add the full path to your $SDK_ROOT/tools to it. If you don't see a line setting the path, you can add one:

export PATH=${PATH}:<path to your $SDK_ROOT/tools>