Creation of Linux databases import and export and some basic instructions

Some basic instructions related to the database The great God can skip directly, may sometimes often do not use, but when used to find not.

The following is a brief statement of the commonly used database-related statements

First view MySQL related directory under Linux
Var/lib/mysql--------The storage path of the MySQL database data file

Run path determined, execute import, export MySQL database command
First, export the database with the mysqldump command
(Note: CD to MySQL running path, then execute command):
1. Export Data and table structure:
Mysqldump-u User name-p password database name > database name. sql

Note that my server configuration permissions are special so you need to use Muysqldump-h 127.0.0.1-u Username-p password database name > your own name for the database. SQL (the sentence is the same as the sentence, there is always a sentence for you)
Mysqldump-uroot-p dbname > dbname. sql

Mysqldump-h 127.0.0.1-uroot-p dbname > dbname. sql

After exporting you can log on to FTP to find this SQL file directly download it, or use the SCP command to download

You will be prompted to enter your password after hitting enter
2. Export table structure only
Mysqldump-u User name-p password-d database name > database name. sql

Example: mysqldump-uroot-p-D dbname > dbname. sql

Second, import the database
1, first build empty database
Mysql>create database dbname;
2. Import the database
Method One:
(1) Select database
Mysql>use dbname; Example: Mysql>use hljz
(2) Setting the database encoding
Mysql>set names UTF8;
(3) Import data (note the path to the SQL file)
Mysql>source/home/xxxx/dbname. sql; /home/xxxx/dbname.sql the path to your database file on the server

Creating a Linux database import and export and some basic instructions