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

C# mysql¶ÁÈ¡Àà

 using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.Types;
using MySql.Data.MySqlClient;
/// <summary>
/// C#²Ù×÷mysql»ùÀà
/// </summary>
public class MySqlobj
{
private MySqlConnection conn;
private MySqlCommand com;
private bool _alreadyDispose = false;
#region ¹¹ÔìÓëèØ¹¹
public MySqlobj()
{
try
{
conn = new MySqlConnection(ConfigurationManager.AppSettings["mysqlconn"]);
conn.Open();
com = new MySqlCommand();
com.Connection = conn;
}
catch (Exception ee)
{
throw new Exception("Á¬½ÓÊý¾Ý¿â³ö´í");
}
}
~MySqlobj()
{
Dispose();
}
protected virtual void Dispose(bool isDisposing)
{
if (_alreadyDispose) return;
if (isDisposing)
{
// TODO: ´Ë´¦ÊÍ·ÅÊÜ¿Ø×ÊÔ´
if (com != null)
{

com.Dispose();
}
if (conn != null)
{
try
{
conn.Close();
conn.Dispose();
}
catch (Exception ee)
{
}
finally
{
conn = null;
}
}
}
// TODO: ´Ë´¦ÊÍ·Å·ÇÊÜ¿Ø×ÊÔ´¡£ÉèÖñ»´¦Àí¹ý±ê¼Ç
_alreadyDispose = true;
}
#endregion
#region IDisposable ³ÉÔ±
public void Dispose()
{
Dispose(true);
GC.SuppressFinalize(this);
}
#endregion
#region »ñÈ¡DataSet
public DataSet GetDataSet(string sqlString)
{
DataSet ds = new DataSet();
try


Ïà¹ØÎĵµ£º

mysql ÕÒ»ØÃÜÂë

 
1.  Í£µ½ÔËÐеÄmysql:    /etc/init.d/mysql stop
2.  ʹÓÃskip-grant-tablesÕâ¸öÑ¡ÏîÆô¶¯MySQL£º  /usr/bin/mysqld_safe --skip-grant-tables &
3.  ÏÖÔÚ¿ÉÒÔ²»ÓÃÃÜÂë½øÈëmysql ÁË¡£
     #  myql
    >   ......

mysqlµÄ´óСдÎÊÌâ

 
´óСдÃô¸ÐÐÔ
1¡¢Êý¾Ý¿âºÍ±íÃû
ÔÚMySQLÖУ¬Êý¾Ý¿âºÍ±í¶ÔÓ¦ÓÚÔÚÄÇЩĿ¼ÏµÄĿ¼ºÍÎļþ£¬Òò¶ø£¬ÄÚÔڵIJÙ×÷ϵͳµÄÃô¸ÐÐÔ¾ö¶¨Êý¾Ý¿âºÍ±íÃüÃûµÄ´óСдÃô¸ÐÐÔ¡£ÕâÒâζ×ÅÊý¾Ý¿âºÍ±íÃûÔÚUnixÉÏÊÇÇø·Ö´óСдµÄ£¬¶øÔÚWin32ÉϺöÂÔ´óСд¡£
×¢Ò⣺ÔÚWin32ÉÏ£¬¾¡¹ÜÊý¾Ý¿âºÍ±íÃûÊǺöÂÔ´óСдµÄ£¬Äã²»Ó¦¸ÃÔÚͬһ¸ö²éѯÖÐʹÓà ......

MySQLµ¼³öµ¼ÈëÃüÁîµÄÓÃÀý

¡¡1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
¡¡¡¡2.µ¼³öÒ»¸ö±í
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
¡¡¡¡3.µ¼³öÒ»¸öÊý¾Ý¿â½á¹¹
¡ ......

mysqlÖÐÎÄÂÒÂëÎÊÌâµÄ½â¾ö·½·¨£¬¾­Êµ¼Ê¼ìÑé¿ÉÒÔÓõÄ

ÍøÉϵĽâ¾ö·½·¨´ó¶àÊÇÒªÐÞ¸ÄmysqlÅäÖÃÎļþ£¬¶ÔÎÒÃDz»Êʺϡ£jhostÖ÷Ò³ÉÏ¿´µ½ÆªÎÄÕ£¬µ«ÀïÃæËµµÄÇý¶¯Ôç¾ÍÊÇÀÏÇý¶¯ÁË£¬»³ÒÉËûÊÇ´ÓÍøÉϸ´ÖƹýÀ´µÄÀϰ汾£¬²»ÖªÊÇ·ñÄÜÓá£ÏÖÔÚ°ÑÎÒ×Ô¼ºµÄ½â¾ö·½°¸Ìù³öÀ´£¬¹©´ó¼Ò²Î¿¼£¬»¶Ó­ÅúÆÀÖ¸Õý¡£
´ó¼Ò×¢ÒâºìÉ«²¿·Ö£¬·Ï»°²»¶à˵£º
µÚÒ»²½£ºÍøÒ³Í·ÉèÖãº
<%@ page contentType="text/html ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ