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

Today, the editor will share with you the relevant knowledge points about how to export the MySQL database in Linux. The content is detailed and the logic is clear. I believe most people still know too much about this knowledge, so share this article for your reference. I hope you can get something after reading this article.

1. Export the database using the mysqldump command (pay attention to the installation path of mysql, that is, the path of this command):

1. Export data and table structure: mysqldump-u username-p password database name > database name .SQL # / usr/local/mysql/bin/ mysqldump-uroot-p abc > abc.sql will be prompted for password after typing enter

2. Only export table structure mysqldump-u user name-p password-d database name > database name. SQL # / usr/local/mysql/bin/ mysqldump-uroot-p-d abc > abc.sql

Note: / usr/local/mysql/bin/-> data directory of mysql

Second, import the database

1. First create an empty database mysql > create database abc

2. Import the database

Method 1:

(1) Select database mysql > use abc

(2) set database code mysql > set names utf8

(3) Import data (note the path of sql file) mysql > source / home/abc/abc.sql

Method 2:

Mysql-u username-p password database name # mysql-uabc_f-p abc

It is recommended to use the second method of import.

These are all the contents of the article "how to export MySQL database in Linux". Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more 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.