MYSQL common commands) _ MySQL

MYSQL common commands (to) bitsCN. com1. export the entire database mysqldump-u username-p -- default-character-set = latin1 database name> exported file name (the default database encoding is latin1) mysqldump-u wcnc-p smgp_rj_wcnc> wcnc. SQL 2. export a table mysqldump-u user name-p database name table name> exported file name mysqldump-u wcnc-p smgp_apps_wcnc users> wcnc_users. SQL 3. export A database structure mysqldump-u wcnc-p-d-add-drop-table smgp_1__wcnc> d: wcnc_db. SQL-d no data-add-drop-table add a drop table 4 before each create statement. import database A: Enter the mysql database console using the commonly used source command, such as mysql-u root-p mysql> use database and then use the source Command. the following parameter is the script file (as used here. SQL) mysql> source wcnc_db.sqlbitsCN.com