LinuxÏÂmysqlÖÐÎÄÂÒÂë½â¾ö·½·¨
ÉÏ´ÎÔÚÅöµ½ÕâÎÊÌ⣬ÔÚÍøÉÏÕÒÁ˽â¾ö·½·¨£¬¿ÉÊÇû¼ÇÏÂÀ´¡£ÕâÐÇÆÚÒª»»»úÆ÷£¬Òª°ÑÔÀ´linuxϵÄmysqlÊý¾Ý¿âÒƵ½Áíһ̨·þÎñÆ÷ÉÏ¡£°²×°suseϵͳ¡¢ÔÙÅäÖÃtelnet¡¢ftp·þÎñ¡¢°²×°java JDK²¢ÅäÖá¢ÔÙ°²×°eclipseºÍmysql,ÓÖ»¨ÁËÒ»ÌìµÄʱ¼ä¡£¸Ð¾õ»¹ÊDz»ÊìÁ·£¬ÅäÖ÷À»ðǽÀÏÊDz»Äܽ«telnetºÍftp·þÎñÅÅÍâ¡£mysqlÓÖÅöµ½ÁËÖÐÎÄÂÒÂëÎÊÌ⣬ÓÖÔÚÍøÉÏÕÒÒ»ÕÒ£¬ÏÖÔڰѽâ¾ö·½·¨ÏȼÇÏÂÀ´°É¡£
ϵͳ»·¾³:suse linux server 10,mysql 5.0
°²×°mysqlºó£¬Ä¬ÈϵÄ×Ö·û¼¯ÊÇlatin1¡£ÔÚlinuxÏ°²×°mysql²»ÏñÔÚwindowsÉÏ°²×°ÄÇÏñ£¬¿ÉÒÔÑ¡Ôñ×Ö·û¼¯(¼´Ê¹µ±Ê±Ê¹ÓÃÁËĬÈϵÄ×Ö·û¼¯£¬°²×°ºóÒ²¿ÉÒÔÔÚ°²×°Ä¿Â¼ÏÂÐÞ¸Ämy.iniÎļþ£©£¬µ«ÊÇÔÚlinux¾Í²»Ì«Ò»ÑùÁË¡£
ÔÚshellÊäÈëmysqlµÇ½ºó:
mysql>show variables like '%char%';
»Ø³µºóÏÔʾ:
+---------------------£+-----££--------------
| Variable_name | Value
+-----------------------+-££------------------
| character_set_client | latin1
| character_set_connection | latin1
| character_set_database | latin1
| character_set_filesystem | binary
| character_set_results | latin1
| character_set_server | latin1
| character_set_system | utf8
| character_sets_dir | /usr/share/mysql/charsets/
+---------------------+£££-------------------
Õâ¾ÍÊÇËüĬÈϵÄÉèÖá£
½ÓÏÂÀ´µ½/usr/share/mysql/Ŀ¼Ï£¬½«my-medium.cnfÎļþ(ʹÓÃÆäËüʵÀýÅäÖÃÎļþÒ²ÐÐ)¿½±´µ½/etcĿ¼Ï£º
pds:~# cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
pds:~# vi /etc/my.cnf
·Ö±ðÔÚÈçϼ¸ÏîÖÐÌí¼Ó×Ö·û¼¯£º
[client]
default-character-set=gb2312
[mysqld_safe]
default-character-set=gb2312
[mysqld]
default-character-set=gb2312
#default-table-type=innodb
[mysql]
default-character-set=gb2312
ÔÙÖØÆômysqlÈÃÅäÖÃÉúЧ:
pds:~# service mysql restart
Shutting down MySQL done
Starting MySQL done
Ôٴεǽmysqlºó£¬²é¿´±äÁ¿£º
mysql>show variables like '%char%';
+---------------------£+-----££--------------
| Variable_name | Value
+-----------------------+-££------------------
| character_set_client | gb2312
| character_set_connection | gb2312
| character_set_database | gb2312
| character_set_filesystem | binary
| character_set_results | gb2
Ïà¹ØÎĵµ£º
Ò»¡¢VMware Tools°²×°ÊÖ¼Ç(For Linux Guest OS)
ΪʲôҪװ VMware Tools£¿
ÒòΪËü¿ÉÒÔ¸ÄÉÆ Virtual Machine µÄÔËÐÐÐÔÄÜ£¬¶øÇÒ¿ÉÒÔÈà Host OS ºÍ Guest OS
»¥Í¨ÓÐÎÞ£¬ÕâÑùÎÒÃǾͲ»ÓÃÉËÄԽҪ¼ÜÉèʲô·þÎñÆ÷£¬À´¹µÍ¨Á½¸ö OS£¬ÏÖÔÚ¾ÍÈÃÎÒÃÇ¿ªÊ¼°É£¡
VMware ToolsËùÔÚλÖãºVMware °²×°Â·¾¶ \VMware\VMware
Workstati ......
¡¡¡¡1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡ mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡ mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
¡¡¡¡2.µ¼³öÒ»¸ö±í
¡¡¡¡ mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> ......
Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓжÔÆäË ......
1¡¢È¡×Ö¶Î×¢ÊÍ
Select COLUMN_NAME ÁÐÃû, DATA_TYPE ×Ö¶ÎÀàÐÍ, COLUMN_COMMENT ×Ö¶Î×¢ÊÍ
from INFORMATION_SCHEMA.COLUMNS
Where table_name = 'companies'##±íÃû
AND table_schema = 'testhuicard'##Êý¾Ý¿âÃû
AND column_name LIKE 'c_name'##×Ö¶ÎÃû
2¡¢È¡µÃ±í×¢ÊÍ
Select table_name ±íÃû,TABLE_COMMENT ±í×¢ÊÍ ......
1. man ¶ÔÄãÊìϤ»ò²»ÊìϤµÄÃüÁîÌṩ°ïÖú½âÊÍ
eg:man ls ¾Í¿ÉÒԲ鿴lsÏà¹ØµÄÓ÷¨
×¢£º°´q¼ü»òÕßctrl+cÍ˳ö£¬ÔÚlinuxÏ¿ÉÒÔʹÓÃctrl+cÖÕÖ¹µ±Ç°³ÌÐòÔËÐС£
2. ls ²é¿´Ä¿Â¼»òÕßÎļþµÄÊô*£¬ÁоٳöÈÎһĿ¼ÏÂÃæµÄÎļþ
eg: ls /usr/man
ls -l
a.d±íʾĿ¼(directory)£¬Èç¹ûÊÇÒ»¸ö"-"±íʾÊÇÎļþ£¬Èç¹ûÊÇlÔò±íʾÊÇÒ»¸öÁ¬½ÓÎļþ ......