Common MySQL Commands

Console Login

Win + R run cmd, open command Console, enter:

MYSQL-H [hostname]-u [username]-P

If you are prompted: "MySQL" is not an internal or external command, nor is it an available program or batch file.

Indicates that there are no environment variables configured for MySQL, the workaround is:

1. Add MySQL to the environment variable, appended to the PATH environment variable

D:\Program Files\mysql\mysql_server_5.5\bin

2. Go to MySQL installation directory D:\Program files\mysql\mysql_server_5.5\, hold down SHIFT, right click on the Bin folder, select "Open Command Window Here" in the pop-up menu, then run the MySQL command to log in.

Export SQL file

mysqldump-h [localhost]-u [username]-P [dbname] >[location]

* Note: location indicates a local directory, such as D:/export.sql

Import SQL file

source [Location]

Common MySQL Commands