ÈçºÎÐÞ¸ÄMYSQLµÄ×Ö·û±àÂë
²é¿´×Ö·û¼¯ÉèÖÃ
mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.02 sec)
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charset
Ïà¹ØÎĵµ£º
»·¾³:
fedora11 , mysql5.1.34Ô´Âë°²×°£º
×°ÁËÒ»Ìì°ëһֱûÓгɹ¦£¬ºóÀ´·ÅÆúÁË£¬ÒòΪfedora11µÄԴϲ»µ½mysqlËùÒÔÖ»ÄÜ·ÅÆúÔÚfedora11ϵݲװ£¬×ª¶ø¸Äµ½unbuntu9.04Éϰ²×°£¬µ«ÊÇÏëÏëÎÊÌâÊÇûÓÐ
½â¾öµÄ£¬½ñÌìÓÖ×ªÒÆµ½fedoraϸ㣬·¢ÏÖ²»Êǰ²×°mysqlÄÑ£¬ÊÇӦΪ×Ô¼º¶Ôlinuxϵͳ²»Ê ......
¡¡¡¡1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡ mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡ mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
¡¡¡¡2.µ¼³öÒ»¸ö±í
¡¡¡¡ mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> ......
ÉÏ´ÎÔÚÅöµ½ÕâÎÊÌ⣬ÔÚÍøÉÏÕÒÁ˽â¾ö·½·¨£¬¿ÉÊÇû¼ÇÏÂÀ´¡£ÕâÐÇÆÚÒª»»»úÆ÷£¬Òª°ÑÔÀ´linuxϵÄmysqlÊý¾Ý¿âÒÆµ½Áíһ̨·þÎñÆ÷ÉÏ¡£°²×°suseϵͳ¡¢ÔÙÅäÖÃtelnet¡¢ftp·þÎñ¡¢°²×°java JDK²¢ÅäÖá¢ÔÙ°²×°eclipseºÍmysql,ÓÖ»¨ÁËÒ»ÌìµÄʱ¼ä¡£¸Ð¾õ»¹ÊDz»ÊìÁ·£¬ÅäÖ÷À»ðǽÀÏÊDz»Äܽ«telnetºÍftp·þÎñÅÅÍâ¡£mysqlÓÖÅöµ½ÁËÖÐÎÄÂÒÂëÎÊÌ⣬ÓÖÔÚ ......