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
Ïà¹ØÎĵµ£º
1. Êý¾Ý¿â
Çл»Êý¾Ý¿â£º use mydb
2. ʼþ
²é¿´Ê¼þ£º show events
Æô¶¯µ÷¶ÈÆ÷: set global event_scheduer = 1;
²é¿´ÊÇ·ñÆô¶¯£º show variables like 'event_scheduler';
3. ±¸·Ý
ÔÚadministatorÖеÄbackupÖÐÎÞ·¨±¸·ÝÊý¾Ý¿âµÄʼþ¡£ÐèÒªÊÖ¶¯½«´´½¨Ê¼þµÄ½Å±¾Ìí¼Óµ½sql±¸ ......
PL/SQLÓïÑÔ
1¡¢¿ÉÖ´Ðв¿·Ö£¨BEGIN£©
×é³ÉÓï¾ä£º
±äÁ¿¸³ÖµÓï¾ä¡£
Á÷³Ì¿ØÖÆÓï¾ä¡£
Êý¾Ý²éѯ¡¢Êý¾Ý²Ù×Ý¡¢ÊÂÎñ¿ØÖÆÓï¾ä¡£
ÓαêÓï¾ä¡£
2¡¢¿ÉÖ´Ðв¿·Ö£¬SQLÓï¾äµÄʹÓÃ
ÔÚ¿ÉÖ´Ðв¿·Ö£¬¿ÉÒÔʹÓÃSQLÓï¾ä£¬µ«ÊDz»ÊÇËùÓеÄSQLÓï¾ä¶¼¿ÉÒÔʹÓá£
¿ÉÒÔʹÓõÄÖ÷ÒªÓУºSELECT¡¢INSERT¡¢UPDATE¡¢DE ......
±¾ÎÄÈí¼þµÄÏÂÔØµØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......