How to import database to your Mysql instance

1.Use the following commands to import the sakila database to your Mysql instance

Solution:

# wget https://downloads.mysql.com/docs/sakila-db.tar.gz

# tar -xvf sakila-db.tar.gz

# mysql -uroot -pmsandbox < sakila-db/sakila-schema.sql

# mysql -uroot -pmsandbox < sakila-db/sakila-data.sql

 2.The following commands will import the world database to your MySQL instance

Solution:

 # wget https://downloads.mysql.com/docs/world-db.tar.gz

# tar -xvf world-db.tar.gz

# mysql -uroot -plearning_mysql < world-db/world.sql

 

 3.The following commands will import the test_db database to your MySQL instance

Solution:

 # git clone https://github.com/datacharmer/test_db.git

# cd test_db

# cat employees.sql | mysql -uroot -psekret

 

测试结果：