mysql on suse linux ϵͳÃüÁî±Ê¼Ç
SLES 11
ÉèÖÃmysql·þÎñ×Ô¶¯Æô¶¯×´Ì¬
chkconfig mysql on
(chkconfig mysql off)
Ìí¼Ó/ɾ³ýmysql·þÎñ
/sbin/chkconfig --del mysql
/sbin/chkconfig --add mysql
²é¿´mysql°æ±¾
mysql -V
mysqld -V
ÆôÍ£ mysql
service mysql start
service mysql stop
service mysql restart
Ïà¹ØÎĵµ£º
/***************************by
garcon1986********************************/
1.´´½¨±í¸ñʱ´íÎó£º ERROR 1005: Can't
create table (errno: 150)
Õâ¸ö´íÎóÊÇÓÐÓÉÓÚÖ÷±íºÍÒýÓñíµÄÍâ¼ü¹ØÁª×ֶζ¨Òå²»Ò»ÖÂÒý·¢µÄ¡£
¼ì²éÁ½¸ö±íµÄ¹ØÁª×Ö¶ÎÊÇ·ñÀàÐͱàÂëÍêȫһÖ¡£
ÁíÍ⻹ÓÐÒ»ÖÖ¿ÉÄܾÍÊǹØÁª×Ö¶ÎÔÚÒýÓñíÖÐ ......
mysqlË÷ÒýÏê½â,Õª×Ô¡¶MySQL 5ȨÍþÖ¸ÄÏ¡·
±¾ÎĽéÉÜÁËÊý¾Ý¿âË÷Òý£¬¼°ÆäÓÅ¡¢È±µã¡£Õë¶ÔMySQLË÷ÒýµÄÌØµã¡¢Ó¦ÓýøÐÐÁËÏêϸµÄÃèÊö¡£·ÖÎöÁËÈçºÎ±ÜÃâMySQLÎÞ·¨Ê¹Óã¬ÈçºÎʹÓÃEXPLAIN·ÖÎö²éѯÓï¾ä£¬ÈçºÎÓÅ»¯MySQLË÷ÒýµÄÓ¦Óᣱ¾ÎÄÕª×Ô¡¶MySQL 5ȨÍþÖ¸ÄÏ¡·(3rd)µÄ8.9½Ú¡£(2007.07.0 ......
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëǰ±ØÐëûÓпոñ£¬·ñÔòÈÃÄãÖØÐÂÊäÈëÃÜÂë. Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµ ......
/*
* linux/fs/bitmap.c
*
* (C) 1991 Linus Torvalds
*/
/* bitmap.c contains the code that handles the inode and block bitmaps */
#include <string.h>
#include <linux/sched.h>
#include <linux/kernel.h> // һЩÄں˳£Óú¯ÊýµÄÔÐζ¨Òå
......
Á½ÖÖ·½Ê½£º
Ò»ÖÖÊÇͨ¹ýÖÕ¶ËÊÖ¶¯¹ÒÔØ¼ÓÉϲÎÊý: -o iocharset=utf8
È磺# mount /dev/sdb1 -t vfat /mnt/usb/ -o iocharset=utf8
µÚ¶þÖÖÊÇͨ¹ý¼ÓÈëÄÚºËÖ§³ÖÔÚFile systems ---> DOS/FAT/NT Filesystems --->ÖÐÓÐÁ½ÏîÐÞ¸ÄΪ£ ......