Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQLµ¼Èë/µ¼³ö.sqlÎļþ


µ¼³ö.sqlÎļþ
1.½«Êý¾Ý¿âtransfer_server_dbµ¼³öµ½transfSRV.sqlÎļþÖУº
    mysqldump -u root -p transfer_server_db > /home/eric/transfSRV.sql
2.½«Êý¾Ý¿âtransfer_server_dbÖеÄdevice_info_tableµ¼³öµ½table.sqlÎļþÖУº
    mysqldump -u root -p transfer_server_db device_info_table > /home/eric/table.sql
3.½«Êý¾Ý¿âmydbµÄ½á¹¹µ¼³öµ½transfSRV.sqlÎļþÖУº
    mysqldump -u root -p transfer_server_db --add-drop-table > /home/eric/transfSRV.sql
µ¼Èë.sqlÎļþ
1¡¢µÇ½MySQL
    mysql -uroot -p;
2¡¢´´½¨Êý¾Ý¿â
    create database transfer_server_db;
3¡¢µ¼ÈëÊý¾Ý¿â½á¹¹Îļþ
    mysql -u root -p transfer_server_db < /home/eric/transfSRV.sql
¸ü¸ÄrootÔ¶³ÌȨÏÞ
1¡¢ÔÊÐírootÓû§Ê¹ÓÃÃÜÂëabc´Ó%µØÖ··¢ÆðÔ¶³Ì·ÃÎÊ
    mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'abc' WITH GRANT OPTION;
    mysql>FLUSH RIVILEGES


Ïà¹ØÎĵµ£º

MySql³£ÓÃÃüÁî

1. Êý¾Ý¿â
Çл»Êý¾Ý¿â£º  use mydb
2. ʼþ
 ²é¿´Ê¼þ£º   show events
 Æô¶¯µ÷¶ÈÆ÷:  set global event_scheduer = 1;
 ²é¿´ÊÇ·ñÆô¶¯£º show variables like 'event_scheduler';
3. ±¸·Ý
ÔÚadministatorÖеÄbackupÖÐÎÞ·¨±¸·ÝÊý¾Ý¿âµÄʼþ¡£ÐèÒªÊÖ¶¯½«´´½¨Ê¼þµÄ½Å±¾Ìí¼Óµ½sql±¸ ......

PL/SQLÓïÑÔ£¨¶þ£©

PL/SQLÓïÑÔ
1¡¢¿ÉÖ´Ðв¿·Ö£¨BEGIN£©
    ×é³ÉÓï¾ä£º
 
±äÁ¿¸³ÖµÓï¾ä¡£
Á÷³Ì¿ØÖÆÓï¾ä¡£
Êý¾Ý²éѯ¡¢Êý¾Ý²Ù×Ý¡¢ÊÂÎñ¿ØÖÆÓï¾ä¡£
ÓαêÓï¾ä¡£
2¡¢¿ÉÖ´Ðв¿·Ö£¬SQLÓï¾äµÄʹÓÃ
ÔÚ¿ÉÖ´Ðв¿·Ö£¬¿ÉÒÔʹÓÃSQLÓï¾ä£¬µ«ÊDz»ÊÇËùÓеÄSQLÓï¾ä¶¼¿ÉÒÔʹÓá£
¿ÉÒÔʹÓõÄÖ÷ÒªÓУºSELECT¡¢INSERT¡¢UPDATE¡¢DE ......

CentOS+Apache+Mysql+Php°²×°¼°ÓÅ»¯ÅäÖÃС¼Ç


±¾ÎÄÈí¼þµÄÏÂÔØµØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ