MySQL:Import Data to MySQL(By *.sql)
如果你拿到的数据文件是:*.sql,那么你可以按照下列方式导入数据到MySQL:
mysql -u[username] -p [database_name] < [xxx.sql,This is your MySQL Data Dump]
1 2 3 |
[root@adamhuanlinux software]# mysql -u*** -p ********* < *********.sql Enter password: [root@adamhuanlinux software]# |
另一种方式: 在“mysql>”提示符下,进入需要导入数据的目标库中:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
mysql> show databases; +-----------------------------+ | Database | +-----------------------------+ | information_schema | | ********* | | mysql | | performance_schema | | wordpress_data | +-----------------------------+ 5 rows in set (0.00 sec) mysql> create database import_data_testing; Query OK, 1 row affected (0.00 sec) mysql> show databases; +-----------------------------+ | Database | +-----------------------------+ | information_schema | | ********* | | import_data_testing | | mysql | | performance_schema | | wordpress_data | +-----------------------------+ 6 rows in set (0.00 sec) mysql> use import_data_testing; Database changed mysql> |
执行导入:
source [*.sql,This is your Data File.]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 |
mysql> select database(); +---------------------+ | database() | +---------------------+ | import_data_testing | +---------------------+ 1 row in set (0.00 sec) mysql> mysql> show tables; Empty set (0.00 sec) mysql> mysql> source /software/import_data.sql (... ...很多额外的输出) Query OK, 2 rows affected (0.00 sec) Records: 2 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> mysql> show tables; +-------------------------------+ | Tables_in_import_data_testing | +-------------------------------+ | wp_commentmeta | | wp_comments | | wp_links | | wp_options | | wp_post_views | | wp_postmeta | | wp_posts | | wp_qiniu | | wp_term_relationships | | wp_term_taxonomy | | wp_termmeta | | wp_terms | | wp_usermeta | | wp_users | | wp_wysija_campaign | | wp_wysija_campaign_list | | wp_wysija_custom_field | | wp_wysija_email | | wp_wysija_email_user_stat | | wp_wysija_email_user_url | | wp_wysija_form | | wp_wysija_list | | wp_wysija_queue | | wp_wysija_url | | wp_wysija_url_mail | | wp_wysija_user | | wp_wysija_user_field | | wp_wysija_user_history | | wp_wysija_user_list | +-------------------------------+ 29 rows in set (0.00 sec) mysql> |
————————————————————————————————
Done。