How to export and import .sql files under Linux command

How to export and import .sql files under Linux command

This article describes how to export and import .sql files under Linux commands. Share with you for your reference, the details are as follows:

1. Export the database using the mysqldump command (note the installation path of mysql, which 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

After pressing Enter, you will be prompted to enter a password

2. Export only the table structure

mysqldump -u username -p password -d database name> database name.sql

#/usr/local/mysql/bin/mysqldump -uroot -p -d abc > abc.sql

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

2. Import database

1. First create an empty database

mysql>create database abc;

2. Import database

Method 1:

(1) Select a database

mysql>use abc;

(2) Set the database encoding

mysql>set names utf8;

(3) Import data (pay attention to the path of the sql file)

mysql>source /home/abc/abc.sql;

Method 2:

mysql -u username -p password database name < database name.sql

#mysql -uabc_f -p abc < abc.sql

The second method is recommended for importing.

Note: There is a command line mode and sql commands

The above is the editor's method of exporting and importing .sql files under the Linux command. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • How to configure the display format of the Linux command prompt
  • How to switch from root to ordinary user to execute scripts or commands in Linux shell scripts
  • The meaning of the return value of the linux command
  • Two ways to change passwords in Linux through Shell script commands
  • Detailed explanation of mathematical operations examples in Linux command line
  • Solve the problem that all linux commands cannot be used

<<:  Detailed explanation of nginx server installation and load balancing configuration on Linux system

>>:  WeChat applet learning wxs usage tutorial

Recommend

JavaScript to achieve simple drag effect

This article shares the specific code of JavaScri...

Introduction to document.activeELement focus element in JavaScript

Table of contents 1. The default focus is on the ...

JavaScript to implement simple carousel chart most complete code analysis (ES5)

This article shares the specific code for JavaScr...

MySQL 5.7.20 installation and configuration method graphic tutorial (win10)

This article shares the installation and configur...

Methods and steps to access Baidu Maps API with JavaScript

Table of contents 1. Baidu Map API Access 2. Usin...

Write a publish-subscribe model with JS

Table of contents 1. Scene introduction 2 Code Op...

How to migrate mysql storage location to a new disk

1. Prepare a new disk and format it with the same...

Teach you how to write maintainable JS code

Table of contents What is maintainable code? Code...

Web Design Tutorial (4): About Materials and Expressions

<br />Previous Web Design Tutorial: Web Desi...

Sample code for making desktop applications with vue + Electron

1.vue packaging Here we use the vue native packag...

How to set mysql5.7 encoding set to utf8mb4

I recently encountered a problem. The emoticons o...