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

mysqlµÄ±¸·ÝºÍ»¹Ô­µÄ±àÂëÎÊÌâ½â¾ö


½ñÌìÐèÒª´ÓÔ¶³Ì·þÎñÆ÷downÒ»¸öuchomeµÄÊý¾Ý¿âÏÂÀ´£¬ÔÚ±¾µØ»¹Ô­¡£
·¢ÏÖÒ»¸öºÜ²»Ë¬µÄÊÂÇ飺Զ³Ì8G£¬NºËµÄlinux»úÆ÷£¬±¸·Ý»¹Ô­²Ù×÷˳ÁïÁïµÄ£¬¿ÉÊÇÔÚ±¾µØµÄwindows£¬2GÆÕͨPCÉÏ£¬²Å100MµÄÎļþ£¬ÓÃuchome×Ô´øµÄ·Ö¾í±¸·Ý»¹Ô­£¬»ù±¾ÉÏÖм䶼»á¶Ïµô£¬ÒªÃ´Ìáʾ“Ö´ÐÐʱ¼ä¹ý³¤”£¨¸Ä³É200Ã룬·Ö¾íΪ20M¶¼²»ÐУ©£¬ÒªÃ´¾ÍÊÇÖÐ;°×ÆÁ¡£
µÃÁË£¬ÓÃmysqldump±¸·ÝµÄÒ»¸ö¶ÀÁ¢ÎļþÀ´ÔËÐÐÃüÁîÐл¹Ô­°É¡£
Ê×ÏÈÔËÐл¹Ô­Óï¾ä£º
mysql -uroot -p123456 mydatabase < d:\backupdatabase.sql
ʱ¼ä»ºÂýµØÊÅÈ¥£¬Ò»¿ÚË®ºÈÍ꣬Éϸö²ÞËù£¬ÔÙÁï´ïһϣ¬ÖÕÓÚÍê³ÉÁË£¨ÔÚÔ¶³Ìlinux·þÎñÆ÷ÉÏÒ²¾Í20ÃëµÄ¹¦·ò£¡£©
È»ºó¸üлº´æ£¬·¢ÏÖÊý¾ÝÂÒÂëÁË£¬ß×£¬ÎÒ±¸·ÝµÄʱºòÊÇÇ¿ÖÆµÄgbk±àÂë°¡£¡¿´¿´±¸·ÝµÄÓï¾ä£º
mysqldump -uroot -p123456 –default-character-set=gbk mydatabase > /usr/local/mysql/backup/backup20091026.sql
û´í°¡£¡ÒѾ­ÉèÖÃÁËĬÈÏ×Ö·û¼¯ÎªgbkÁË£¬¿´À´¿ÉÄÜÊÇÔÚ»¹Ô­µÄʱºòÒ²ÒªÉèÖðɣ¬ÓÚÊÇÐ޸Ļ¹Ô­Óï¾ä£¬ÊÖ¹¤Ö¸¶¨×Ö·û±àÂë
mysql -uroot -p123456 font –default-character-set=gbk mydatabase < d:\backupdatabase.sql
ÓÖÊÇÂþ³¤µÄµÈ´ý…Ë¢ÐÂÒ³ÃæÒ»¿´£¬ÏÖÔÚÂÒÂë½â¾öÁË¡£
×ܽ᣺ÔÚ²»Í¬µÄ²Ù×÷ϵͳºÍÊý¾Ý¿â»·¾³Ö®¼ä±¸·ÝÓ뻹ԭʱ£¬»¹ÊÇÁ½±ß¶¼Ç¿ÖÆÖƶ¨Ò»¸ö×Ö·û¼¯×î±£ÏÕ¡£


Ïà¹ØÎĵµ£º

MysqlÏà¹Ø

1¡¢°²×°Ä¿Â¼:
½«my.iniÖÐ:
datadirµÄÖµ¸ü¸ÄΪ£º"sql/data/"
basedirµÄÖµ¸ü¸ÄΪ£º"sql"
2¡¢½øÈësql/data/"£¬É¾³ýÎļþ¼ÐÍâµÄËùÓÐÎļþ¡£
net start mysql»Ø³µ……
×¢ÒâбÏß/
ÐÞ¸Äpswd
·½·¨1£ºmysqladmin -u root -p "old password" "new password"   (´ËÃüÁîÎÞ·¨°ÑÃØÃÜÇå¿Õ)
·½·¨2£º ......

PHPºÍMySQL Web¿ª·¢ (Ô­ÊéµÚ4°æ) »úе¹¤Òµ

http://www.xhsd.com.cn/books/views.asp?plucode=711126281
Õâ±¾Êé±»³ÆÎªPHPºÍMySQLµÄ“Ê¥¾­”£¬×Ðϸ¿´ÁËһϣ¬µÄÈ·Óкܶà¶Àµ½µÄµØ·½¡£
Ê×ÏÈ£¬ÄÚÈÝÃ÷È·Í»³ö¡£Õâ±¾ÊéµÄÄ¿µÄÊǶÔPHPºÍMySQL×öÉîÈëdz³öµÄ·ÖÎö£¬¶ÔÆäWebÓ¦ÓÃ×öÁ˽ÏÈ«ÃæµÄ²ûÊö£¬Àý×Ó¾­µäʵÓá£
Æä´Î£¬Ð¡£PHP5.3£¬MySQLµÄ´æ´¢¹ý³ÌºÍ´æ´¢ÒýÇæ£¬Ajax¼¼ ......

java¿ª·¢ÖÐMysqlÖÐÎÄÂÒÂëÎÊÌâµÄ½â¾ö

     MysqlÔÚĬÈÏÇé¿öϽ¨Á¢±íµÄ×Ö·û±àÂëÊÇlatin1£¬ËùÒÔÔÚ²åÈëÖÐÎÄʱ»á³ö´í¡£
eg£º
1¡¢²é¿´±í½¨Á¢µÄsqlÔ´Â룺
1: sqlÃüÁshow create table users
2:
3: ½á¹û£º
4: CREATE TABLE `users` (
5: `userID` int(10) unsigned NOT NULL AUTO_INCREMENT,
6: `userName` varchar(4 ......

C#²Ù×÷MySQLÊý¾Ý¿âµÄ¼òµ¥Àý×Ó


×÷Õß: ÍõÕßÖ®½£(http://www.albertsong.com/)  ÈÕÆÚ: 2008-01-05 22:10
×ÖÌå´óС: Ð¡ ÖР´ó
ʾÀýÑÝʾÁËÓÃC#²Ù×÷MySQLµÄ·½·¨£¬ÌṩÁËÈý¸ö¿ÉÖØÓõÄÀàMySqlDBUtil,MySqlPageUtil,Page¡£
±¾Ê¾ÀýÓÉ C#²Ù×÷AccessÊý¾Ý¿âµÄ¼òµ¥Àý×Ó£¨http://www.albertsong.com/read-56.html£©Ð޸ĶøÀ´¡£
1.Ê×ÏÈÏÂÔ ......

C# Á¬½ÓMySqlµÄ·½·¨


1.´Óhttp://prdownloads.sourceforge.net/mysqldrivercs/MySQLDriverCS-n-EasyQueryTools-3.0.18.exe?downloadÉÏÏÂÔØMySQLDriverCS. 
2.°ÑMySQLDriverCS.dll.Ìí¼Óµ½.netµÄ×é¼þ 
3.ʹÓ÷½·¨ 
 ÏÂÃæÊÇ´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó:
ÏÂÃæÊÇ´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó:
using MySQLDriverCS;
MySQLConnection conn ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ