Mysql import. run the following command in the dos mysql installation directory/BIN directory: mysql-u username-p databasename use database_name and then run the following command mysql> source 111. SQL is 111 by default. the SQL path must be put in the bin in mysql for successful import !!! ~~ Yeah .. 1. export mysqldump-u user name-p Database Name> exported file name mysqldump-u wcnc-p smgp_1__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 has no data -- add-drop-table adds a drop table 4 before each create statement. import common source commands to the mysql Database Console, such as mysql-u root-p mysql> use Database, and then use the source command. The following parameters are script files (as used here. SQL) mysql> source d: \ wcnc_db. SQL