MySQL

• Dump the table structure
  mysqldump  --compact --no-data
• Dump the data only
  mysqldump --compact --no-create-info
• Dump the routines
  mysqldump  --skip-opt --no-create-info --no-data --routines --triggers 

 

Recently I'm using PRADO framework for some web application development. It comes to deploy to the server side.
The server is running Debian 3.1r3

• apt-get install php5-dev php5-mysql php5-sybase php5-sqlite libmysqlclient-dev freetds-dev
  
• apt-get install make
• pecl install PDO
• pecl install PDO_SQLITE
• pecl install PDO_MYSQL
• pecl install PDO_DBLIB

At the last step, it report:
pear/PDO_DBLIB requires PHP extension "pdo" (version >= 1.0)
No valid packages found
install failed