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

ͨÓõÄmysql dump³ÌÐò

¿ÉÒÔÊÊÓÃÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃû£¬ gzipѹËõ , ´øÊä³öbuffer , Ö§³Ö·Ö¿â·Ö±í
ÐèÒª¸¨Öú´úÂëºÍMakefie , ÏÂÃæÊÇÖ÷³ÌÐò´úÂ룬 
/**
* mysqlÊý¾Ý±ídump³ÌÐò
* @author : cheng limin
* @date : 2010-1-18
*
* ʹÓÃÑùÀý:
*./dump_mysql -c ../conf/dump.conf
* -t xml
* -s "select * from * where punish_type != 0"
* -f ctu.txt
*/
#include <iostream>
#include <string>
#include <errno.h>
#include <time.h>
#include <sys/time.h>
#include "mysql.h"
#include "INIParser.h"
#include "tbZip.h"
using namespace __gnu_cxx;
using namespace std;
#define OUT_FORMAT_TXT 0 /* Êä³öÎļþ¸ñʽ ÐÐÁиñʽ */
#define OUT_FORMAT_XML 1 /* Êä³öÎļþ¸ñʽ xml¸ñʽ */
/* ´ÓÃüÁîÐлñµÃµÄ²ÎÊý */
string g_confFile = ""; /* ÅäÖÃÎļþ */
string g_sectionName = ""; /* ÅäÖÃÎļþsection½ÚÃû³Æ */
string g_sql = ""; /* ÐèÒªÖ´ÐеÄsql */
string g_fileName = ""; /* Êä³öÎļþÃû */
/* ´ÓÅäÖÃÎļþ»ñµÃµÄ²ÎÊý */
string g_fieldSep = ""; /* ×ֶνáÊø */
string g_lineSep = ""; /* Ðнáβ */
string g_host = ""; /* Ö÷»úÃû */
int g_port = 3306; /* ¶Ë¿ÚºÅ ĬÈÏ3306 */
string g_user = ""; /* Óû§Ãû */
string g_passwd = ""; /* ÃÜÂë */
string g_db = ""; /* ¿âÃû */
string g_charset = ""; /* Êý¾Ý¿â×Ö·û¼¯ */
int g_compType = 0; /* Êä³öÎļþѹËõ·½Ê½ ĬÈÏ0 0=²»Ñ¹Ëõ 1=gzip */
int g_outFormat = OUT_FORMAT_TXT; /* Êä³öÎļþ¸ñʽ , ĬÈÏΪÎı¾*/
FILE *g_fp; /* Êä³öÎļþ¾ä±ú */
tbZip *g_tz; /* ѹËõÎļþ¹¤¾ßÀà */
/**
* ʹÓðïÖú
*
* @param progName ³ÌÐòÃû
*/
void usage(const char *progName)
{
fprintf(stderr, "************************************************* \n");
fprintf(stderr, "Usage: %s \n", progName);
fprintf(stderr, " -c configeFile ³ÌÐòµÄÅäÖÃÎļþ \n");
fprintf(stderr,


Ïà¹ØÎĵµ£º

c# Á¬½ÓMySqlÊý¾Ý¿âµÄÁ½ÖÖ·½·¨

1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØ
Ö·£º
http://sourceforge.net/projects/mysqldrivercs/
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½
MySQLDriver.dll
£¬È»ºó½«
MySQLDriver.dll
Ìí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ

MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
 
using

S ......

ASP.NETÓëMySqlµÄÁ¬½Ó——Êý¾Ý¿â·ÃÎʲÙ×÷

1.¶Á³ö·½Ê½
DataReaderºÍDataSet¶¼¿ÉÒÔʵÏÖ¶ÔÊý¾Ý¿âÊý¾ÝµÄ²éѯ·µ»Ø£¬µ«Ç°ÕßÖ»ÄÜÌṩ¿ìËٵIJéѯ·½Ê½£¬ºóÕß»¹¿ÉÒÔʵÏÖ¶ÔÊý¾ÝµÄÌí¼Ó¡¢Ð޸ġ¢É¾³ý¹¦ÄÜ¡£
£¨1£©DataReader·½Ê½¶ÁÈ¡£º
string sConnString = "server=localhost;User Id=root;password=root;Persist Security Info=True;database=db_user";
MySqlConnection myC ......

MySQLÊý¾Ýµ¼ÈëÓëµ¼³ö

¡¡ÏÖÔÚʹÓÃMySQLµÄÔ½À´Ô½¶àÁË£¬ÎÒÒ²ÓÃËü×öÁË×ÔÒѵÄÁôÑÔ°å¡£ÔÚʹÓùý³ÌÖУ¬ 
ÂýÂýµØ 
¾ÍÒªÇó¶ÔËüµÄ¹ÜÀí 
¹¦ÄÜÐèÒª½üÒ»²½µÄÕÆÎÕ£¬²»½öÊÇÎÒ£¬Ò²ÊǺܶàÍøÓѵÄÒªÇó¡£ÏÖÔÚÓÐһЩÎÊÌâÊǹؠ
ÓÚÈçºÎ 
´ÓMySQLÖе¼³öÊý¾Ý£¬ 
ÒÔ±ãÓÃÔÚ±¾µØ»òÆäËüµÄÊý¾Ý¿âϵͳ֮ÉÏ£»ÒÔ¼°½«ÏÖÓÐÊý¾Ýµ¼ÈëMySQLÊý¾Ý¿âÖ ......

mysqlÊý¾ÝË«Ïòͬ²½

2.»·¾³ËµÃ÷
2.1    Ó²¼þ»·¾³(Á½Ì¨»úÆ÷µÄÓ²¼þ»·¾³Ïàͬ)
CPU
Inter(R) Pentium(R) Dual CPU E5200 @2.50GHz
ÄÚ´æ´óС
384MB
Ó²ÅÌ´óС
8GB
ÆäËü˵Ã÷
±¾»úÆ÷ΪÐéÄâ»ú£¬ÆäÓÐÁ½¿éÍø¿¨£¬Ò»¶ÔÍø¿¨Ö±Á¬£¬Ò»¶Ô½ÓÈë½»»»»ú
 
CPU
Inter(R) Pentium(R) Dual CPU E5200 @2.50GHz
ÄÚ´æ´óС
384MB
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ