Linux MySQL backup import

Connect to a remote Linux database

Mysql-hip-u User name-p password

mysql-h192.168.1.180-uroot-p123456

What databases are listed

show databases;

Create a database

Create DATABASE xxx;

Switch database

Use XXX database;

List all tables in the database

Show tables;

Backing Up the database

Mysqldump-hip-u User name-p password database name > backup path

mysqldump-h192.168.1.180-uroot-p123456 lmcms_160718 >/usr/local/119_sql_bak_liuzhen/119_lmcms_ 160718.2016-7-31.bak

Import Database

The first way: Mysql-hip-u username-p Password Database < backup address

mysql-h192.168.1.180-uroot-p123456 lmcms_160718 < 46_119_lmcms_160716.2016-7-18.bak

Second way: source Backup Address

View table Structure

Show CREATE TABLE Cms_user;

This article from "Liu" blog, reproduced please contact the author!

Linux MySQL backup import