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=”http://yui.yahooapis.com/2.5.2/build/reset-fonts-grids/reset-fonts-grids.css”>

  • 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:

    http://gdata.youtube.com/apiplayer?key=DEV_KEY

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

     

    Functions

    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: http://code.google.com/apis/youtube/chromeless_player_reference.html#Examples

    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.

    image

       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

    e.g.

    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: http://code.google.com/apis/youtube/js_api_reference.html#Operations

    Sample Code: http://code.google.com/apis/youtube/js_api_reference.html#Examples

    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

    image

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

    image


    TIPS

    Why use Dynamic publishing

    Description

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

    Pros

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

    Cons

    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.