场景:一个项目的数据出了问题,为了不影响线上的运行,只能把数据库下载到本地进行分析,刚好本地有安装phpmyadmin,数据库文件大概500M左右,用phpmyadmin开始导入,出现如下问题:
------------------------------------------------------------------------------
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at admin@example.com to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log.
Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.
-----------------------------------------------------------------------------
于是尝试在window下的DOS操作,那么mysql如何在Dos下导入大数据库?
首先找到mysql.exe的安装目录,我的是在D:\phpstudy_pro\Extensions\MySQL5.7.26\bin下,每个人的环境可能不同。再一步步往下操作即可。
下面开始。
1、进入DOS
win+R打开运行,输入cmd,打开DOS
输入:cd D:\phpstudy_pro\Extensions\MySQL5.7.26\bin
再输入:d:
这样就进入了目录D:\phpstudy_pro\Extensions\MySQL5.7.26\bin>
2、接下来登录mysql,
输入:mysql -u root -p
输入密码,就登录到了mysql
3、选择数据库
输入:show databases;
输入:use testdb;显示Database changed
这样就选择好了数据库testdb
4、导入大数据库sql文件
source d:\testdb.sql,回车
执行如下:
Query OK, 27 rows affected (0.02 sec)
Records: 27 Duplicates: 0 Warnings: 0
Query OK, 6 rows affected (0.02 sec)
Records: 6 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql>
看到上面的画面表示运行完成,导入成功了。
在此作个记录,主要怕久了就忘记。