¼òÒ׽ű¾·½±ã±¸·ÝMySQLÊý¾Ý¿â
¼òÒ׽ű¾
·½±ã±¸·ÝMySQL
Êý¾Ý¿â
@echo off
echo.
echo MySQLÊý¾Ý¿â±¸·Ý
echo *****************************
echo.
echo ½ñÌìÊÇ %date%
echo ʱ¼äÊÇ %time%
echo.
echo *****************************
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
md "E:\%Ymd%"
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump" --opt -Q -uadmin -padmin110 --default-character-set=latin1 mydata > "E:\%Ymd%\mytables.sql"
echo.
echo MySQLÊý¾Ý¿â±¸·ÝÍê³É£¬Çë½øÐмì²é¡£¡£¡£
echo.
echo.
pause
Ïà¹ØÎĵµ£º
Õâ¶Îʱ¼äÔÚѧϰC#,ÒªÁ¬½ÓmysqlÊý¾Ý¿â,²»ÖªµÀÔõôÁ¬½Ó ,ºóÀ´gooleÁËÏÂ,·¢ÏÖÒªÏÂÔØÇý¶¯,˳±ã¿´ÁËÏÂÁ¬½ÓµÄexample code
´úÂëºÍjavaÀïÃæµÄ²îºÜ¶à,֮ǰһֱÔÚѧC++ Ҳѧ¹ýÒ»¶Îʱ¼äµÄÇý¶¯¿ª·¢,Ò»ÌýmysqlÇý¶¯,ҲûÔÚÒâ, Çý¶¯ÔÚÐÄÀïÒ»Ö±¶¼ÊǺÜÄÑ
²¢ÇÒÈÝÒ×Ôì³ÉÀ¶ÆÁ,Êý¾Ý½á¹¹¸´ÔӵĴúÃû´Ê,Ò²¾ÍûÔÚÒâ,µ«ÊǺóÀ´Ô ......
nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ
×÷ÕߣºÌïÒÝ(sery@163.com
)
ÆðÒò£ºnagios¿ÉÄÜ¼à¿Øµ½mysql·þÎñµÄÔËÐÐÇé¿ö£¬µ«È·²»ÄÜ¼à¿ØmysqlµÄÖ÷´Ó¸´ÖÆÊÇ·ñÕý³££ºÓÐʱºò£¬Í¬²½ÒѾֹͣ£¬µ«¹ÜÀíÈËԱȴ²»ÖªµÀ¡£
ÏÂÊÖ´¦£ºµÇ½mysql´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G
²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊÇij¸ö´Ó·þÎ ......
ÔÚѧϰ£¼Linux³ÌÐòÉè¼Æ£¾µÚ8ÕÂMySQLÊý¾Ý¿â8.3½Ú£º
ʹÓÃCÓïÑÔ·ÃÎÊMySQL·ÃÎÊÊý¾Ý¿âʱ³¢ÊÔ°ÑSQLÊý¾Ý»»³ÉÁËÖÐÎÄ£¬µ«ÊÇÔÚÔËÐÐʾÀý³ÌÐòʱÖÕ¶ËÊä³öÈ´ÂÒÂ룬MySQL C ÓïÑÔÁ¬½ÓĬÈÏ×Ö·û¼¯ÊÇlatin1
²éÁËÏÂAPIÕÒµ½ÈçϺ¯Êý¿É½â¾öÖÐÎÄÂÒÂëÎÊÌâ¡£
int
mysql_set_character_set(
MYSQL *
mysql,
char
*
csname)
ÃèÊö
¸Ãº¯ÊýÓ ......
1.SELECT USER();
»ñµÃµ±Ç°µÇ½Óû§µÄÓû§ÃûÓëÖ÷»úÐÅÏ¢£¬Ê¹ÓøÃÃüÁî»áÏÔʾÀàËÆÓÚÈçÏÂÐÅÏ¢£ºroot@zxj.lest.vicp.cc£¬@Ç°ÃæÊÇÓû§Ãû£¬ºóÃæÊÇÖ÷»úÃû¡£
2.SHOWÓ÷¨£¬
SHOW DATABASES--ÏÔʾ¶àÉÙ¸öÊý¾Ý¿â£¬Ò²¿ÉÒÔ½Ð×ö±í¿Õ¼ä¡£
SHOW TABLES--ÏÔʾÓжàÉÙ¸ö±í¡£
SHOW VARIABLES--ÏÔʾÊý¾Ý¿â±äÁ¿¡£
SHOW MASTER STATUS.
SHOW C ......
½éÉÜ£º
mysql sha1
a¡£ 1 -- 11λ Êý×Ö
b¡£ 1 -- 8λ Сд×Öĸ
c¡£ 1 -- 8λ Сд×Öĸ + Êý×Ö
d¡£ 1 -- 7λ ×Öĸ + Êý×Ö + ·ûºÅ
e¡£ 1 -- 8λ´óд×Öĸ
»¹ÔÚ¼ÌÐøÉú³ÉÖÐ,ÕæÅå·þÄÌÍ·Õ⺢×ÓŪÁ˺ü¸¸öÔÂÁË¡£
ÏÂÔØµØÖ·
http://down.5luyu.cn ......