Shulou(Shulou.com)06/02 Report--

Most people do not understand the knowledge points of this article "how to import and export MySQL data in the Linux system", so the editor summarizes the following, detailed contents, clear steps, and a certain reference value. I hope you can get something after reading this article. Let's take a look at this "how to import and export MySQL data in the Linux system" article.

1. Export database 1. Export complete data: under table structure + data Linux, you can use the mysqldump command to export the database. The syntax format is as follows:

Mysqldump-u user name-p database name > database name. SQL the following command exports the data and table structure of the abc database:

# / usr/local/mysql/bin/mysqldump-uroot-p abc > abc.sql will be prompted to enter the password after pressing the enter key.

Note: the mysqldump command path is based on your MySQL installation path.

2. Export only the table structure if you only need to export the data table structure of MySQL, you can use the-d option in the following format:

Mysqldump-u user name-p-d database name > database name. SQL the following command exports the table structure of the abc database:

# / usr/local/mysql/bin/mysqldump-uroot-p-d abc > abc.sql II. Import database using mysql command import using mysql command import database format:

Mysql-u user name-p database name the following example imports the backed-up database abc.sql into the database: # mysql-uroot-p123456 using the source command import using the source command requires us to log in to mysql first and create an empty database: mysql > create database abc; # create database mysql > use abc; # use the created database mysql > set names utf8 # set coding mysql > source / home/abc/abc.sql # Import backup database pay attention to the path of the sql file you backed up. The above is about the content of this article on "how to import and export MySQL data in Linux system". I believe we all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more related knowledge, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.