LINUXÖÐmysqlµ¼ÈëÊý¾Ý¿âµÄ¼¸´óÎÊÌ⣡

Õý³£Çé¿öÏ£¬ÎÒÃÇÁ¬½ÓSSH
È»ºóÓõǽ mysql -uroot -pÃÜÂë Êý¾Ý¿âÃû <Òªµ¼ÈëµÄÎļþ.sql
ÕâÑùÔÚLINUXÖУ¬²Ù×÷¿ÉÒÔÓã¡

ÄÇôÎÒÏÖÔÚÏë»»³ÉLINUX¿ØÖÆ̨µÄ·½·¨ÄØ£¿
±ÈÈç
ÔÚLINUXÖÐÎÒÃÇͨ¹ýÖն˵ǼÁËmysql -uroot -p123456 È»ºóµÇ½

mysql> ÕâÀïÎÒÏëÒªµ¼ÈëµÄÎļþ11.sqlµ¼Èëµ½Êý¾Ý¿âÀïÈ¥£¬¸ÃÓÃʲôÃüÁîÄØ£¿


µ±È»·½·¨¶þ£¬Ô¶³Ìµ¼Èë!ÏÖÔÚÎÒÔÚXPϵͳÉÏÈ»ºó¿ÉÒ԰ѱ¾µØµÄÎļþµ¼Èëµ½LINUXÀïµÄMYSQLÊý¾Ý¿â

·½·¨£ºmysql -h119.12.12.11 -uaspchina -paspchina123456 aspchina < d:\aspchina_net.sql

µ«ÊÇÎÒÏëÎÊÏ£¬ÎҵǽÁËXPµÄMYSQL½¿ØÖÆ̨ÀïÓÖÈçºÎÄÜ°ÑSQL½Å±¾µ¼Èëµ½LINUXÉÏÈ¥ÄØ£¿
»òÕßÎÒµÄÕâ¸öÏë·¨¸ù±¾¾Í²»´æÔÚ£¡Èç¹û´æÔÚÕâÑùµÄ·½·¨£¬ÓÃʲôÃüÁî

---

ÄúÒ²¿ÉÒÔͨ¹ýxpÖ´ÐÐ,²»Ò»¶¨ÒªÉÏ´«µ½linuxÉϵÄ
mysql -h119.12.12.11 -uaspchina -paspchina123456 aspchina

source d:\aspchina_net.sql

---

ÒýÓÃ

·½·¨1

mysql-> source /path/your.sql

µÚ¶þ¸öÄú¿ÉÒÔ°Ñsql½Å±¾ÉÏ´«µ½linuxÉÏ,ÔÚÓÃsource /path/your.sqlÖ´ÐоͿÉÒÔÁË

ÕâÌõÎÒÒ»Ö´Ðоͳö´í


SQL code:
mysql> source /home/111.sql
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected (0.01 se