Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

shell Öе÷Óà mysql ²Ù×÷

#!/bin/bash
#ɾ³ý100¸öÊý¾Ý¿âÖеÄ1000¸ö±íµÄ¹ýÆÚÊý¾Ý
DBHOST="127.0.0.1"
DBPWD="pwd"
DBUSER="root"
MYSQLBIN="/usr/local/mysql/bin/mysql"
for((dbindex = 0;dbindex < 100;dbindex++))
do
   for((tabindex = 0;tabindex < 10;tabindex++))
   do
    if [ $dbindex -lt 10 ]; then
  del="delete from gs_map_0${dbindex}.t_${tabindex}";
    else
  del="delete from gs_map_${dbindex}.t_${tabindex}";
    fi
    del=${del}" where Fcreate_time < UNIX_TIMESTAMP() - 86400"
    bin=`${MYSQLBIN} -u${DBUSER} -p${DBPWD} -h${DBHOST} -e"${del}"`
    $bin
    #echo ${bin} 
    #echo $del >>/tmp/aaa.txt
    sleep 5
   done
done
#crontab configure
# 0 3 * * * clear.sh > /dev/null 2>&1


Ïà¹ØÎĵµ£º

MySQL±¸·Ý¡¢»¹Ô­

»¹Ô­Ò»¸öÊý¾Ý¿â:mysql -h localhost -u root -p123456 www<c:\www.sql
±¸·ÝÒ»¸öÊý¾Ý¿â:mysqldump -h localhost -u root -p123456 www > d:\www2008-2-26.sql
//ÒÔÏÂÊÇÔÚ³ÌÐòÖнøÐвâÊÔ
//$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
$command="mysqldum ......

mysqlÊý¾Ý¿â±¸·Ý

E:\databases\MySQL\MySQL Server 5.1\bin>mysqldump --help
mysqldump  Ver 10.13 Distrib 5.1.30, for Win32 (ia32)
By Igor Romanenko, Monty, Jani & Sinisa
This software comes with ABSOLUTELY NO WARRANTY. This is free softwa
and you are welcome to modify and redistribute it under the GPL ......

MySQL×î»ù´¡ÖªÊ¶¼Ç¼

Ò».°²×°
rpm·½Ê½
rpm -ivf MySQL*
tar·½Ê½
tar xzvf mysql-x.xx.tar.gz
cd mysqlp-x.xx    Éú³Émakefile
./congigure   
make              ±àÒë
 
make install
mysql_install_db
¶þ.Æô¶¯¡¢¹Ø±Õ
ser ......

²åÈëMYSQLÖÐÎÄÂÒÂë

1.½¨±í¹ý³ÌÈçÏÂ
create database  test default character set utf8 collate utf8_general_ci
use test;
create table devicedata
(
 ID int auto_increment PRIMARY key ,
 TimeStamp datetime,
 Device_Name varchar(100),
 Tag_Name varchar(100),
 Value varchar(50)
)
2 ......

mysqlÃüÁîÐв»Ö´ÐкÍÃüÁîÐÐÖÐÎÄÂÒÂëµÄ½â¾ö


1£ºMysql ÃüÁî²»¿ÉÒÔÖ´ÐÐ
Ô­Òò £ººÇºÇ ±ÈÈç show databases µÄÃüÁî £¬Ö´ÐÐÍêÖ®ºó ɶҲûÓÐ £¬×Ðϸ ÕÒÁËÔ­Òò £¬Oh my god  ÉÙÁË ·ÖºÅ¡£
Ӧд³É£ºshow databases;
2£ºÃüÁîÐÐÖÐÎÄÂÒÂëÎÊÌâ
ÏÖÏó£ºmysqlµÄĬÈϱàÂëÉèÖÃΪutf-8£¬Ò³ÃæÒÔutf-8µÄ±àÂ뷽ʽдÈëµ½Êý¾Ý¿â¡£Óù¤¾ß²é¿´Ò»ÇÐÕý³££¬µ«´ÓmysqlµÄÃüÁîÐжÁÊý¾Ý³öÀ´× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ