mysqldump — A Database Backup Program for MySQL


There are three general ways to invoke mysqldump:

shell> mysqldump [options] db_name [tables]

shell> mysqldump [options] --databases db_name1 [db_name2 db_name3...]

shell> mysqldump [options] --all-databases

In its simplest form, the mysqldump utility can be used like this:

mysqldump –-user [user name] –-password=[password] [database name] > [dump file]

this will include both the schema and data as well.

If you need only the schema use the -d or --no-data option

e.g. mysqldump -d -u root -pp@ssword mydatabase > mydatabase.sql

Reference: MySQL :: MySQL 5.0 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program

Yahoo YUI CSS Library

First of all, include the external stylesheet: <link rel=”stylesheet” type=”text/css” href=””>

  • CSS Reset (neutralizes browser CSS styles)
  • CSS Base (applies consistent style foundation for common elements)
  • CSS Fonts (foundation for typography and font-sizing)
  • CSS Grids (more than 1,000 CSS-driven wireframes in a 4KB file)
  • Tutorial Video on CSS Library

    How to use the YouTube embedded Video Player


    YouTube Chromeless Player API


    Chromeless player SWF URL:

    note: it is using and videoId is no longer part of the url as it was used in the javascript player api.



    The following functions are available in addition to the ones listed in the JavaScript API section below:

    loadVideoById(videoId:String, startSeconds:Number):Void

    cueVideoById(videoId:String, startSeconds:Number):Void

    setSize(width:Number, height:Number):Void

    Sample Code:

    YouTube JavaScript Player API


    Embedding the YouTube player using SWFObject

    We recommend using SWFObject to embed any players that will be accessed using the JavaScript API. This will allow you to detect the end user’s Flash Player version (the JavaScript API requires Flash Player 8 or higher), and also will get rid of the ‘Click to activate this control’ box when using Internet Explorer to view the player. To enabled the API in the SWF, you must pass in the parameter enablejsapi=1.


       Additional SWF Url Parameters that allows you to set things like color, border, autoplay, ‘Genie’ menu, related videos etc…

    Getting the Player Reference

    e.g. function onYouTubePlayerReady(playerId) { ytplayer = document.getElementById(“myytplayer”); }

    Issuing Calls

    e.g. function play() { if (ytplayer) { ytplayer.playVideo(); } } <a href=”javascript:void(0);” onclick=”play();”>Play</a>

    Subscribing to Events


    function onYouTubePlayerReady(playerId) { ytplayer = document.getElementById(“myytplayer”); ytplayer.addEventListener(“onStateChange”, “onytplayerStateChange”); }

    function onytplayerStateChange(newState) { alert(“Player’s new state: ” + newState); }

    Functions and Events exposed by the Javascript Player API:

    Sample Code:

    How to embed Flash Player content using SWFObject dynamic publishing


    STEP 1: Create alternative content using standards compliant markup

    STEP 2: Include the SWFObject JavaScript library in the head of your HTML page

    STEP 3: Embed your SWF with JavaScript


    STEP 4: Use JavaScript Objects to define your flashvars, params and object’s attributes



    Why use Dynamic publishing


    Create alternative content using standards compliant markup and embed Flash content with unobtrusive JavaScript.


    Avoids ‘click-to-activate’ mechanisms in Internet Explorer 6+ and Opera 9+ and is easy to author (even without using this generator).


    The embedding of Flash content relies on JavaScript, so if you have the Flash plug-in installed, but have JavaScript disabled or use a browser that doesn’t support JavaScript, you will not be able to see your Flash content, however you will see alternative content instead. Flash content will also not be shown on a device like Sony PSP, which has very poor JavaScript support, and automated tools like RSS readers are not able to pick up Flash content.