source /.sql的地址;直接执行,将.sql的表导入到制定的数据库。
source /var/www/html/tp5/o2o_sql.sql;
mysql> source /var/www/html/tp5/o2o_sql.sql;
Query OK, 0 rows affected (0.40 sec)
Query OK, 0 rows affected (0.43 sec)
Query OK, 0 rows affected (0.38 sec)
Query OK, 0 rows affected (0.46 sec)
Query OK, 0 rows affected (0.35 sec)
Query OK, 0 rows affected (0.41 sec)
Query OK, 0 rows affected (0.67 sec)
Query OK, 0 rows affected (0.42 sec)
Query OK, 0 rows affected, 1 warning (0.00 sec)