ÎÒµÄMysqlÖØ×°Ê§°Ü£¬½â¾ö°ì·¨
ÖØÐ°²×°£¬³öÏÖ/etc/init.d/mysql: line 115: /etc/mysql/debian-start: ûÓиÃÎļþ»òĿ¼
invoke-rc.d: initscript mysql, action "start" failed.
ʹÓÃÃüÁsudo aptitude purge mysql-server mysql-server-5.0
È»ºóÔÚÖØÐ°²×°....
apt-get install mysql-server-5.0
Ïà¹ØÎĵµ£º
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ ......
mysqldump -u[user] -p[password] [databasename] > [dump_name]
ÔÚ½« dump_name Õâ¸öµµ°¸¸´ÖƵ½Áíһ̨¼ÆËã»úÉÏ
Áíһ̨¼ÆËã»úÉÏÏȽøÈëmysql
½¨Á¢Ò»¸ö database ÔÙÖ´ÐÐÏÂÁÐÖ¸Áî
mysql -u[user] -p[password] [database_name] < [dump_name]
MYSQL¼¸ÖÖ±¸·Ý·½·¨¸ÅÊö
MysqlÊý¾Ý
¿â±¸·ÝÖ÷ÒªÓÐ4Ö ......
²åÈëÒ»Ìõ¼Ç¼:
mysql> insert into table_name (column_name1,column_name2,.) values (value1,value2,..);
¸üÐÂÒ»Ìõ¼Ç¼£º
mysql> update tbl_name
s ......
Ò»¸ömysqlµÄÁªºÏ²éѯÁÐ×Ó£¬ºÜ»ù±¾µÄ£¬²»¹ýºÜʵÓá£
ÏÈ¿´Êý¾Ý±í¡£Êý¾Ý±íclass£º
-------------------------------
id cname
-------------------------------
1 ÄÐ×°
2 ŮƤ¿ã
3 Å®²ÊÃÞ
-------------------------------
class±í´æ·ÅµÄÊDzúÆ·µÄ´óÀàà ......
MySql »ù±¾²Ù×÷
Ò»¡¢»ù´¡
1£º µÇ½£ºmysql –u username –p <»Ø³µ¡· È»ºóÊäÈëÃÜÂë
2£º²é¿´Êý¾Ý¿â£ºshow databases£»
3£ºÊ¹ÓÃÊý¾Ý¿âuse databasename;
4: ³£¿´Êý¾Ý¿â±í show tables£» µ«ÊÇǰÌáÊÇÄãÒѾʹÓÃÁËuse ÃüÁÈç¹ûûÓÐ µÄ»°¿ÉÒÔʹÓà show tables from databasename £»
5£º ²é¿´Êý ......