MySQL Command export Import

1: First upload the generated. sql file xftp to the server root directory

2: Enter Mysql===============mysql-u root-p

3: Build the database ====================create database dyxw;

4: Into the library ====================use Dyxw;

5: Import ====================source dyxw.sql;

6: Look inside what table ========show tables;

7: Look at the contents of web_ad this table ======select * from Web_ad;

MySQL export: mysqldump-uroot-p passwd db >db.sql

Mysqldump-u with user name-p with password database name > database name. sql

Import from/Under the original server to the current server/down Scp-p port db.sql [email protected]:/

To modify the MySQL password:

Method 1: Use the Set password command

Mysql-u Root

mysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');

Method 2: Use Mysqladmin

mysqladmin-u root Password "Newpass"

If Root has already set a password, use the following method

mysqladmin-u root password Oldpass "Newpass"

MySQL Command export Import