Thursday, 13 June 2013

Dumping MySQL Stored Procedures, Functions and Triggers

MySQL 5 has introduced some new interesting features, like stored procedures and triggers. I will show in this small post how we can backup and restore these components using mysqldump.
mysqldump will backup by default all the triggers but NOT the stored procedures/functions. There are 2 mysqldump parameters that control this behavior:
  • –routines - FALSE by default
  • –triggers - TRUE by default
This means that if you want to include in an existing backup script also the triggers and stored procedures you only need to add the –routines command line parameter:
mysqldump <other mysqldump options> --routines outputfile.sql
Let’s assume we want to backup ONLY the stored procedures and triggers and not the mysql tables and data (this can be useful to import these in another db/server that has already the data but not the stored procedures and/or triggers), then we should run something like:
mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt <database> > outputfile.sql
and this will save only the procedures/functions/triggers of the . If you need to import them to another db/server you will have to run something like:

Komponent TChromeTabs

Our new live network monitoring application required an up to date user interface that allowed data to be displayed and manipulated in the most intuitive way possible. We tried many different UI approaches until we settled on the modern look and feel of Chrome's tabs. We have decided to open source our implemetation to allow other developers to benefit from it's features. It is currently available for Delphi 7 through Delphi XE3 (32 and 64 bit).
You can download the latest source and binary demo here. You can also grab the source from Google Code.

Here's a what TChromeTabs can do.

Chrome Tabs overview

  • The tab container can be tranparent and painted over Vista Aero glass.
  • Tabs can have any level of transparency.
  • All movement and style transitions can be optionally animated.
  • Tabs can be pinned to the side of the container.
  • Each tab can have both an image and overlay image. 

Chrome Tabs Unicode
  • Full BiDi and Unicode support
  • BiDi tabs and controls can be aligned to the right.
  • BiDi text can be aligned to the right.* Unicode supported in IDE versions from Delphi 2009 

Chrome Tabs Glows

  • Mouse glow - a glow is painted over the hot tabs.
  • Modified glow - a glow is drawn moving across the top of the a tab when it has been modified. 
Chrome Tabs Gradiants

  • All controls support gradiants and alpha levels.
  • Different look and feel for Active, Not Active and Hot states.
  • All controls support borders.
  • Tabs can be any height.
  • Control shapes can be altered using events. 
Chrome Tabs Tab Widths

  • Dyanmically resizing tabs
  • Maximum and minimum tab sizes
  • Various text truncation options including ellipses and fade.
  • Intelligent content visibility. Tab details will be shown hidden depending on the width of the tab.
  • Auto hide close button when tab width is too small. 
Chrome Tabs Scrolling
  • Full scrolling support.
  • Scroll buttons can be overlayed and automatically hidden.
  • Scrolling automatically enabled when minimum tab width is reached.
  • Tabs are autoscrolled when a tab is being dragged. 
Chrome Tabs Drag Drop

  • Fully animated tab drag and drop
  • Drag and drop tabs to new positions.
  • Fully automated drag and drop tabs between containers.
  • Built in tab drag image. All you need to do is supply the wincontrol in an event. 

Chrome Tabs Close Button

  • Intelligent tab resizing when the close button is clicked. 
  • Demo application allows access to all TChromeTabs features and properties including a look and feel editor.
  • Options and LookAndFeel properties can be saved to/loaded from a file or stream. 

Install Fortesreport community Delphi 7 dan RX Berlin

Download  Pertama2 kita harus punya file installernya terlebih dahulu, download