mysqlÊý¾Ýµ¼³öµ½sqlserver·½·¨
ÕâÀïÊÇʹÓÃODBCÀ´×ª»»Êý¾Ý¿âµÄ¡£
1.°²×°mysqlÊý¾Ý¿âµÄODBCÇý¶¯£¬mysql¹ÙÍøÓÐÏÂÔØhttp://dev.mysql.com/downloads/connector/odbc/
2.´ò¿ª¿ØÖÆÃæ°å\¹ÜÀí¹¤¾ß\Êý¾ÝÔ´ODBC£¬ÔÚÓû§DSNÖÐÌí¼ÓÒ»¸öMySQL ODBC Êý¾ÝÔ´¡£
3.½Ó×ÅÔÚÏÂÃæµÄ´°ÌåÖÐÊäÈëÊý¾ÝÔ´Ãû³Æ£¬Èçmysqlodbc£»È»ºóÊäÈë·þÎñÆ÷ServerµØÖ·£¨localhost»òÆäËû£©£¬Óû§User£¬ÃÜÂëPassword£¬ÊäÈëÕýÈ·ºóÑ¡ÔñÒªµ¼ÈëµÄÊý¾Ý¿â¡£ÔÚÁ¬½ÓÑ¡Ïîconnect optionsÖиù¾ÝÐèÒªÉèÖÃMySqlʹÓõĶ˿ÚportºÍ×Ö·û¼¯Character Set¡£ ×Ö·û¼¯Ò»¶¨ÒªºÍMysql·þÎñÆ÷Ïà¶ÔÓ¦£¬Èç¹ûMysqlʹÓÃÁËgbk×Ö·û¼¯£¬ÔòÒ»¶¨ÒªÉèÖÃ×Ö·û¼¯Îªgbk£¬·ñÔòµ¼Èëµ½Sql Server¿ÉÄÜ»á³öÏÖÎʺÅÂÒÂë¡£
4.´ò¿ªsql serverÆóÒµ¹ÜÀíÆ÷£¬Ð½¨Ò»Êý¾Ý¿âMySql¡£Ñ¡Ôñ¸ÃÊý¾Ý¿â£¬µ¥»÷ÓÒ¼üÑ¡ÔñËùÓÐÈÎÎñ\µ¼ÈëÊý¾Ý¡£
5.Ñ¡ÔñÊý¾ÝԴΪÆäËü(ODBCÊý¾ÝÔ´)£¬Óû§/ϵͳDSNΪmysqlodbc¡£ÆäÓà¸ù¾ÝÏòµ¼½øÐУ¬¼´¿É½«Êý¾Ý´ÓMySqlÊý¾Ý¿âµ¼Èëµ½MSSQLÊý¾Ý¿âÖС£
µ¼Èëµ½sqlserverµÄÊý¾Ý¿â¿ÉÄÜÓÐЩ±íÓдíÎ󣬱ÈÈç±íÖÐÊý¾Ýδµ¼È룬±íÖ÷¼üδÉèÖã¬×ֶθñʽ²»ÕýÈ·µÈµÈ£¬ÒªÖØÐÂÉèÖûò²åÈë¡£
Ïà¹ØÎĵµ£º
MySqlµÄʱ¼äÀàÐÍÓÐ JavaÖÐÓëÖ®¶ÔÓ¦µÄʱ¼äÀàÐÍ
date ......
Ò»°ãÔÚMYSQLʹÓÃÖÐÎIJéѯ
¶¼ÊÇÓà set NAMES character
character_set_client £¬ÕâÊÇÓû§¸æËßMySQL²éѯÊÇÓõÄʲô×Ö·û¼¯¡£
character_set_connection £¬MySQL½ÓÊܵ½Óû§²éѯºó£¬°´ÕÕcharacter_set_client½«Æäת»¯Îªcharacter_set_connectionÉ趨µÄ×Ö·û¼¯¡£
character_set_results £¬ MySQL½«´æ´¢µÄÊý¾Ýת»»³Écharact ......
¾ÍÎÒÖªµÀµÄÁ½¸öÇø±ð£º
myISAM ²»Ö§³ÖÊÂÎñ
Innodb Ö§³ÖÊÂÎñ
Èç¹ûÐÞ¸ÄmyISAM ΪInnodb£¬ÐèÒª°ÑÔÀ´µÄÊý¾ÝÏÈdump³öÀ´£¬Çå¿Õ±í£¬ÔÚÖØвåÈë
innodbÔÚ/etc/my.cfgµÄÅäÖÃΪ
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_hom ......
¸÷λ¸ßÊֺá£Ð¡µÜѧϰJAVA²»¾Ã£¬È»ºóÔÙÓÃMYSQLÊý¾Ý¿â¡£
ÓÉÓÚÊÇÓñðÈ˵ĵķ¶Àýѧϰ£¬ËùÒÔ³öÏֺܶàÆæ¹ÖµÄÎÊÌâ
ÎÒÓÃ×Ô¼ºµÄMYSQL ·þÎñÆ÷£¬È»ºó°Ñ±ðÈ˵ÄÊý¾Ý¿âµ¼½øÀ´¡£È»ºó³öÏÖ°æ±¾ÎÊÌâ¡£
ÎÊÌâÈçÏÂ
Table './db_librarysys/tb_manager' was created with a different version of MySQL and cannot be read
2010-4-28 22:44 ......
×òÌ죬¹«Ë¾´Ó·þÎñÆ÷ÉϸãÏÂÀ´Ò»¸ö´óµÄÊý¾Ý¿â£¬Îļþ´óСΪ487MB£¬ÓÐͬÊÂ˵½«php.iniµÄÎļþÅäÖÃÖеÄpost_max_size¸ÄΪ±ÈÄãÒªµ¼ÈëµÄÊý¾Ý¿âÎļþ´óһЩµÄ£¬±ÈÈçÏÖÔÚÎÒÒªµÄµ¼ÈëµÄÊý¾Ý¿âÎļþÊÇ487MB£¬ÄÇô¿ÉÒÔ½«´ËÏî¸ü¸ÄΪ£º700MB£¬ÔÙʹÓÃphpMyAdmin¹¤¾ßµÄµ¼È빦ÄÜÀ´ÊµÏÖ£¬µ«ÊÇ£¬ÎÒÊÔÓÃÁË´ËÖÖ·½·¨²»ÄÜ×àЧ£¬È»ºóÓëÓоÑéµÄÅóÓѽ»Á÷£ ......