Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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,


Ïà¹ØÎĵµ£º

mysqlÍü¼ÇrootÃÜÂëµÄ½â¾ö

mysqlÍü¼ÇrootÃÜÂëµÄ½â¾ö
Ò». MySQLÃÜÂëµÄ»Ö¸´·½·¨Ö®Ò»
Èç¹ûÍü¼ÇÁËMySQLµÄrootÃÜÂ룬¿ÉÒÔÓÃÒÔÏ·½·¨ÖØÐÂÉèÖãº
1. KILLµôϵͳÀïµÄMySQL½ø³Ì£»
killall -TERM mysqld
2. ÓÃÒÔÏÂÃüÁîÆô¶¯MySQL£¬ÒÔ²»¼ì²éȨÏ޵ķ½Ê½Æô¶¯£»
safe_mysqld --skip-grant-tables &
3. È»ºóÓÿÕÃÜÂ뷽ʽʹÓÃrootÓû§µÇ¼ MySQL£» ......

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. Êý¾Ý¿âµÄ²¿Êð
£¨1£©Èí¼þµÄ°²×°
A. MySql——±ØÐë°²×°ÔÚCÅÌÏ£¬·ñÔò°²×°mysql-connector-net-6.2.2ºóÎÞÕýÈ·ÅäÖÃ
B. mysql-connector-net-6.2.2——½«MySql.Data.dll·ÅÔÚBinÎļþ¼ÐÏÂ
£¨2£©Êý¾Ý¿âµÄµ¼³öµ¼Èë
MySQL-FrontµÄ"Áí´æÎª"¹¦ÄÜ¿ÉÒÔ½«Êý¾Ý¿âµ¼³öΪ.sqlÎļþ£¬È»ºóÔÙͨ¹ýËüÖ±½Óµ¼Èë.sqlÎļþ¿ ......

MySQLÊý¾Ý¿âÎļþ½éÉÜ

mysqlµÄÊý¾Ý´¢´æÄ¿Â¼ÔÚmysqlµÄÅäÖÃÎļþmy.iniÎļþÉèÖ㬸ñʽÈçÏ£º
# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = d:/cyoa/mysql_cy/
datadir = d:/cyoa/mysql_cy/data/
      ÆäÖÐdatadirĿ¼¶¨ÒåÁËmysqlµÄÊý¾Ý´æ´¢Î»Öã¬MySQLµÄÿ¸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ