Basics of MySQL

First, the storage engine

Mysql>show engines;+--------------------+---------+----------------------------------------------------------------+-------------- +------+------------+| Engine | Support | Comment | Transactions | XA | savepoints |+--------------------+---------+----------------------------------------------------------------+--- -----------+------+------------+| Federated | NO | Federated MySQL Storage Engine | NULL | NULL | NULL | | Mrg_myisam | YES | Collection of identical MyISAM tables | NO | NO | NO | | MyISAM | DEFAULT | MyISAM Storage Engine | NO | NO | NO | | Blackhole | YES | /dev/NULLStorage Engine (anything youWriteto it disappears) | NO | NO | NO | | CSV | YES | CSV Storage Engine | NO | NO | NO | | MEMORY | YES | Hash based, storedinchMemory, useful forTemporary Tables | NO | NO | NO | | ARCHIVE | YES | Archive Storage Engine | NO | NO | NO | | InnoDB | YES | Supports transactions, Row-level locking, and foreign keys | YES | YES | YES | | Performance_schema | YES | Performance Schema | NO | NO | NO |+--------------------+---------+----------------------------------------------------------------+----------- ---+------+------------+9RowsinchSet (0.00Sec

Related introduction: A brief talk on MySQL storage engine (table type)

Second, Import Database script

Import directly on the cmd command line

c:\users\plan-b>mysql-uroot-p1234--p3306 < D:\mysqlscript\sampledb.sql

Import with the source command

Mysql> Source  D:\mysqlscript\sampledb.sql

Basics of MySQL