Common commands for MySQL in work

Connect to local MySQL

Mysql-u root-p

Connect to remote MySQL

Mysql-u root-p-H 192.168.1.2

Export a table in a local database (such as the Users table in export data) Enter the database password after carriage return

mysqldump Databases -u root-p--tables USERS>/usr/tmp/users.sql

Export the remote database a table (users table) Enter the database password after

mysqldump-h192.168.79.206-p3306 Databases -u root-p--tables USERS>/usr/tmp/users.sql

Surface renaming

RENAME TABLE USERS to Users_bak

Keep updating .....

Common commands for MySQL in work