Import and Export mysql database commands in linux

Import and Export mysql database commands in linux

1. Export the database:

Mysqldump 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 you press enter, you will be prompted to enter the 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 the 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 database Encoding
Mysql> set names utf8;
(3) import data (note the path of the SQL file)
Mysql> source/home/abc. SQL;

Method 2:
Mysql-u username-p Password Database Name <database name. SQL
# Mysql-uabc_f-p abc <abc. SQL

We recommend that you use the second method for import.

Note: The command line mode and SQL command are available.