sql还原备份数据

show databases;
create database dbname;
use dbname;
//这一步是为了解决MySQL数据库乱码，具体编码格式根据之前还原的数据库编码来确定，建议都使用utf8
set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set collation_connection = utf8_general_ci;
set collation_database = utf8_general_ci;
set collation_server = utf8_general_ci;
//路径根据你备份的sql文件路径
source C:bdname.sql;