www.yiz.name ================================= Several common use cases: 1. Export the entire database mysqldump -u Username -P Database Name> Export file name mysqldump -u wcnc -p SMGP_APPS_WCNC> wcnc.sql2. Export a table mysqldump -u username -P database name meter> Export file name mysqldump -u wcnc -p smGp_APPS_WCNC USERS> WCNC_USERS.SQL3. Export a database structure mysqldump -u wcnc -p -d --add-drop-table smGp_apps_wcnc> d: /wcnc_db.sql -d no data -Add-drop-table adds one before each CREATE statement Drop Table 4. Import Database Use Source command to enter the MySQL database console, such as mysql -u root -p mysql> Use database then use the source command, the back parameter is a script file (such as used here. SQL) MySQL> Source D: /WCNC_DB.SQL======================================================================================================================================================================================================================================= MySQLDUMP
