MySQL命令行導(dǎo)出數(shù)據(jù)庫
：
1.
導(dǎo)出數(shù)據(jù)庫
：mysqldump -u 用戶名 -p 數(shù)據(jù)庫名 >
導(dǎo)出的文件名
? ?
mysqldump
-u root -p Movie >Movie
.sql
(輸入后會(huì)讓你輸入進(jìn)入MySQL的密碼)
（如果導(dǎo)出單張表的話在數(shù)據(jù)庫名后面輸入表名即可）
mysqldump -u root -p Movie movies>tab_movies.sql
2.
會(huì)看到文件Movie.sql自動(dòng)生成到var/lib/mysql數(shù)據(jù)庫存儲(chǔ)目錄下，如下所示：
root@landen-Lenovo:/var/lib/
mysql# ls
debian
-5.5
.flag ib_logfile1
Movie.sql
news test
ibdata1 metastore_db mysql performance_schema
ib_logfile0 Movie mysql_upgrade_info student
注意：Movie.sql中存放的是之前操作的腳本語言，即增刪改查，創(chuàng)建存儲(chǔ)過程，觸發(fā)器的相關(guān)腳本。 ??
MySQL命令行導(dǎo)入數(shù)據(jù)庫
：
1.
將要導(dǎo)入的.sql文件移至
var/lib/mysql數(shù)據(jù)庫存儲(chǔ)目錄下
2. 進(jìn)入MySQL命令行客戶端：mysql -u 用戶名 -
p
?
?mysql
-u root -
p
(輸入同樣后會(huì)讓你輸入MySQL的密碼)
4. 在MySQL-
Front中新建你要建的數(shù)據(jù)庫，這時(shí)是空數(shù)據(jù)庫，如新建一個(gè)名為news的目標(biāo)數(shù)據(jù)庫
mysql>create database if not exists news;
5. 輸入：mysql>
use 目標(biāo)數(shù)據(jù)庫名
mysql
>use news;
6.
導(dǎo)入文件
：mysql>
source 導(dǎo)入的文件名;
mysql
>
source news.sql;
相關(guān)操作數(shù)據(jù)如下
：
root@landen-Lenovo:/var/lib/mysql# mysql -uroot -
p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
53
Server version:
5.5.29-0ubuntu0.12.04.2
(Ubuntu)
Copyright (c)
2000, 2012, Oracle and/
or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and
/
or its
affiliates. Other names may be trademarks of their respective
owners.
Type
'help;' or '\h'
for
help. Type '\c'
to clear the current input statement.
mysql
>
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| Movie |
| metastore_db |
| mysql |
| performance_schema |
| student |
| test |
+--------------------+
7 rows in set (0.01
sec)
mysql
> create database
if
not exists news;
Query OK,
1 row affected (0.02
sec)
mysql
>
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| Movie |
| metastore_db |
| mysql |
| news |
| performance_schema |
| student |
| test |
+--------------------+
8 rows in set (0.01
sec)
mysql
>
use news;
Database changed
mysql
>
source Movie.sql
Query OK,
0 rows affected (0.02
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.01
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.10
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.33
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.04
sec)
Query OK,
44625 rows affected (0.65
sec)
Records:
44625 Duplicates: 0 Warnings: 0
Query OK,
44027 rows affected (0.51
sec)
Records:
44027 Duplicates: 0 Warnings: 0
Query OK,
44050 rows affected (1.57
sec)
Records:
44050 Duplicates: 0 Warnings: 0
Query OK,
43180 rows affected (0.60
sec)
Records:
43180 Duplicates: 0 Warnings: 0
Query OK,
42200 rows affected (1.03
sec)
Records:
42200 Duplicates: 0 Warnings: 0
Query OK,
42238 rows affected (1.35
sec)
Records:
42238 Duplicates: 0 Warnings: 0
Query OK,
42235 rows affected (0.95
sec)
Records:
42235 Duplicates: 0 Warnings: 0
Query OK,
42237 rows affected (0.98
sec)
Records:
42237 Duplicates: 0 Warnings: 0
Query OK,
42291 rows affected (0.77
sec)
Records:
42291 Duplicates: 0 Warnings: 0
Query OK,
42266 rows affected (1.19
sec)
Records:
42266 Duplicates: 0 Warnings: 0
Query OK,
42270 rows affected (0.90
sec)
Records:
42270 Duplicates: 0 Warnings: 0
Query OK,
42238 rows affected (0.88
sec)
Records:
42238 Duplicates: 0 Warnings: 0
Query OK,
42285 rows affected (1.14
sec)
Records:
42285 Duplicates: 0 Warnings: 0
Query OK,
42285 rows affected (0.64
sec)
Records:
42285 Duplicates: 0 Warnings: 0
Query OK,
42295 rows affected (0.96
sec)
Records:
42295 Duplicates: 0 Warnings: 0
Query OK,
42297 rows affected (0.69
sec)
Records:
42297 Duplicates: 0 Warnings: 0
Query OK,
42253 rows affected (1.11
sec)
Records:
42253 Duplicates: 0 Warnings: 0
Query OK,
42291 rows affected (0.95
sec)
Records:
42291 Duplicates: 0 Warnings: 0
Query OK,
42286 rows affected (0.55
sec)
Records:
42286 Duplicates: 0 Warnings: 0
Query OK,
42260 rows affected (1.12
sec)
Records:
42260 Duplicates: 0 Warnings: 0
Query OK,
42276 rows affected (0.89
sec)
Records:
42276 Duplicates: 0 Warnings: 0
Query OK,
42295 rows affected (0.98
sec)
Records:
42295 Duplicates: 0 Warnings: 0
Query OK,
42296 rows affected (1.10
sec)
Records:
42296 Duplicates: 0 Warnings: 0
Query OK,
21233 rows affected (0.23
sec)
Records:
21233 Duplicates: 0 Warnings: 0
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.06
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.30
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.02
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
3883 rows affected (0.33
sec)
Records:
3883 Duplicates: 0 Warnings: 0
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.02
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.17
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
6040 rows affected (0.14
sec)
Records:
6040 Duplicates: 0 Warnings: 0
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
Query OK,
0 rows affected (0.00
sec)
mysql
>
show tables;
+-------------------+
| Tables_in_news |
+-------------------+
| movie_preferences |
| movies |
| users |
+-------------------+
3 rows in set (0.00
sec)
mysql
> select * from users limit 20
;
+--------+--------+-----+------------+---------+
| UserID | Gender | Age | Occupation | Zipcode |
+--------+--------+-----+------------+---------+
| 1 | F | 1 | 10 | 48067 |
| 2 | M | 56 | 16 | 70072 |
| 3 | M | 25 | 15 | 55117 |
| 4 | M | 45 | 7 | 02460 |
| 5 | M | 25 | 20 | 55455 |
| 6 | F | 50 | 9 | 55117 |
| 7 | M | 35 | 1 | 06810 |
| 8 | M | 25 | 12 | 11413 |
| 9 | M | 25 | 17 | 61614 |
| 10 | F | 35 | 1 | 95370 |
| 11 | F | 25 | 1 | 04093 |
| 12 | M | 25 | 12 | 32793 |
| 13 | M | 45 | 1 | 93304 |
| 14 | M | 35 | 0 | 60126 |
| 15 | M | 25 | 7 | 22903 |
| 16 | F | 35 | 0 | 20670 |
| 17 | M | 50 | 1 | 95350 |
| 18 | F | 18 | 3 | 95825 |
| 19 | M | 1 | 10 | 48073 |
| 20 | M | 25 | 14 | 55113 |
+--------+--------+-----+------------+---------+
20 rows in set (0.06 sec)
?
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號(hào)聯(lián)系： 360901061
您的支持是博主寫作最大的動(dòng)力，如果您喜歡我的文章，感覺我的文章對(duì)您有幫助，請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點(diǎn)擊下面給點(diǎn)支持吧，站長非常感激您！手機(jī)微信長按不能支付解決辦法：請(qǐng)將微信支付二維碼保存到相冊(cè)，切換到微信，然后點(diǎn)擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對(duì)您有幫助就好】元
