ÕÒmysql·þÎñͻȻµ±µôÔÒò
linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔÒò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔÒò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔÒò£¬²»ÖªµÀlinuxûÓÐÀàËÆwindowsµÄcÅÌ£¨¾ßÌåÊÇÄĸöĿ¼£©¿Õ¼ä²»×㣿
dataĿ¼ÏµÄerrÈÕÖ¾
linux ÏÂûÓÐÕÒµ½errÈÕÖ¾
ûÓÐERRÈÕÖ¾£¬ÔòÔÚMYSQLÕâ¸ö²ã´ÎÉÏûʲô°ì·¨ÁË¡£
½¨ÒéÂ¥Ö÷µ½ LINUX °æÈ¥ÎÊһϣ¬²Ù×÷ϵͳ²ãÉÏÓÐʲô¼Ç¼¿ÉÒԲ쿴¡£
ÕÒµ½ err
090626 20:26:58 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000010' (relay_log_pos 318)
090626 20:26:58 [ERROR] Could not find target log during relay log initialization
090626 20:26:58 [ERROR]
¿´ÏÂlinuxµÄ´íÎóÈÕÖ¾ÊÇ·ñÓз¢ÏÖ°É:
tail -f /var/log/messages
¸Ðл´ó¼Ò mysqlÀí½âÓÖÉîÁËЩ
Ïà¹ØÎÊ´ð£º
¶ÔMYSQLÖд洢µÄXML¸ñʽµÄÊý¾Ý½øÐвéѯ¸üÐÂÒÔ¼°É¾³ýij½áµã´¦ÀíµÄÀý×Ó£¬Çë·¢ÎÒÓÊÏ䣬лл£¬
30367940@qq.com
·¢ËͺóÇë»ØÌû£¬ÊÕµ½¼°½áÌû
ÄãÒªmysql¸ÉÂï?
ÂãÇó¿ÉÒÔ¿¼ÂÇ!
¶¥ÉÏÈ¥
¶Á³öÀ´È»ºóÓÃSimpleXML´ ......
ÎҼǵÃÔÚmysqlÖÐÓиöload data infile Óï¾ä¿ÉÒÔ°ÑwordÎĵµµÄÄÚÈݰ´Ò»¶¨¸ñʽµ¼ÈëÊý¾Ý¿â£¬ÕâÑùµ¼ÈëµÄÊý¾ÝÀàÐͺÃÏñÖ»ÄÜÊÇÎı¾¸ñʽµÄÊý¾Ý£¬ÇëÎÊÓÐû¸üºÃµÄ·½·¨¿ÉÒÔµ¼ÈëÊý¾Ý¿â¡£
1¡£Èç¹ûÎÒÃÇÒª°ÑÊÔÌâµ¼ÈëÌâ¿â£¬ÄÇà ......
mysql±È½Ï²Ë£¬
×Ö¶ÎÀïÃæÓиö MB ,²»ÊÇÊýÖµÐÍ£¬ÆäËüÓÐЩ¡°Î´Öª¡±£¬Ôõô²ÅÄܵóö×îÖÕÏà¼ÓµÄ½á¹û£¿
SQL code:
mysql> select * from t;
+----------+
| size |
+----------+
| 0.47 MB |
| NU ......
ÎÒÓõÄÊÇeclipse-jee-galileo-SR1-win32 tomca6.0 Mysql5.1 ÏÂÔØÏÂÀ´µÄÇý¶¯ÊÇmysql-connector-java-5.1.10-bin.jar ÎÒ½«Ëü·ÅÔÚÁËD:\Ŀ¼Ï²¢Ð´½øÁËϵͳ±äÁ¿calsspath »¹°ÑËü·Å½øÁËeclipse¹¤×÷ÇøµÄ ÏîÄ¿\WebContent\W ......