CREATE  TABLE IF NOT EXISTS `dncms`.`dncms_articles` (
  `article_id` INT(11) NOT NULL AUTO_INCREMENT ,
  `title` TEXT NOT NULL ,
  `body` TEXT NOT NULL ,
  `user_id` INT(11) NULL DEFAULT NULL ,
  `published` TINYINT(4) NULL DEFAULT '0' ,
  `keywords` TEXT NULL DEFAULT NULL ,
  `description` TEXT NULL DEFAULT NULL ,
  `datetime` DATETIME NULL DEFAULT NULL ,
  `language_id` INT(11) NOT NULL ,

<?php
    class class_mysql{
    
        //Инициализируем переменные
        private $mysql_host = "localhost";
        private $mysql_login = "qwerty";
        private $mysql_passwd = "123456";
        private $mysql_database;
        private $mysql_connect;
        private $sql_error;

<roleManager enabled="true" defaultProvider="MySQLRole">
   <providers>
      <clear/>
      <add name="MySQLRole" 
           connectionStringName="MySQLConStr" 
           applicationName="/" 
           type="MySql.Web.Security.MySQLRoleProvider, MySql.Web, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/>
   </providers>
</roleManager>

<membership defaultProvider="MySQLMembership">
   <providers>
      <clear/>
      <add name="MySQLMembership" 
           connectionStringName="MySQLConStr" 
           enablePasswordRetrieval="false" 
           enablePasswordReset="true" 
           requiresQuestionAndAnswer="true" 
           applicationName="/" 
           requiresUniqueEmail="false" 

#!/bin/bash
(while(true); do  \
(mysql -e 'show innodb status \G' | grep undo\ log\ entries ; sleep 1 ;  \
mysql -e 'show innodb status \G' | grep undo\ log\ entries ) |    \
egrep '[0-9][0-9][0-9][0-9]' |awk '{print $10;}' ; done ) | \
perl -e '$t = ROWS_IN_TABLE; while(1) { \
$n ++; $nn; $a = <>; $b = <>; $nn += ($b-$a); \
printf "Rate: %d, avg: %d, %0.3f%% complete, done in %d sec\n", \
$b-$a, $nn/$n, ($b/$t)*100, ($t-$b)/($nn/$n); }';

#How to install mysql 5 on centos 5
yum install php-mysql mysql mysql-server
/sbin/chkconfig --levels 235 mysqld on
/etc/init.d/mysqld start