Home  >  Article  >  Database  >  mysql文件的导入_MySQL

mysql文件的导入_MySQL

WBOY
WBOYOriginal
2016-06-01 13:47:351076browse

bitsCN.com

       很多时候都会将数据库文件导出到本地或者从网站直接导出下载。下载到本地后对于mysql数据库的还原,只能通过导入数据库。通过UE或者其他编辑器查看sql语句明显不方便,也不便于查询,因此需要导入到mysql数据库中进行还原。步骤很简单:

(1)登录mysql数据库

(2)use databases;

(3)source d:1.sql

导入过程的时间跟数据量成正比。

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn