使用MySQL WorkBench导入...错误ERROR 1046(3D000) [英] Importing using MySQL WorkBench... error ERROR 1046 (3D000)

问题描述

方案:在本地构建RoR环境以进行开发.生产在EngineYard/GitHub上.现在一切正常，除了不导入DB.

Scenario: building a RoR enviroment locally for development. Production is on EngineYard / GitHub. All now working ok, except DB isn't importing.

我有一个从我的产品EY网站获取的.sql文件.现在，我需要将其导入到本地的MySQL中.我正在使用Workbench(因为这是我的新手)，但是下面出现错误.

I have a .sql file that i've taken from my prod EY site. Now i need to import it to my MySQL locally. I'm using Workbench (as i'm new to this), but getting error below.

请帮助?

08:07:43恢复/home/james/Downloads/Futology.sql运行:mysql --defaults-extra-file ="/tmp/tmpAVeE58/extraparams.cnf" --host = localhost --user = root --port = 3306 --default-character-set = utf8 --comments<第22行的"/home/james/Downloads/Futology.sql"错误1046(3D000):未选择数据库

08:07:43 Restoring /home/james/Downloads/Futology.sql Running: mysql --defaults-extra-file="/tmp/tmpAVeE58/extraparams.cnf" --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "/home/james/Downloads/Futology.sql" ERROR 1046 (3D000) at line 22: No database selected

操作失败，退出代码为1 08:07:43导入 /home/james/Downloads/Futology.sql完成了1个错误

Operation failed with exitcode 1 08:07:43 Import of /home/james/Downloads/Futology.sql has finished with 1 errors

推荐答案

工作台不多，但是从命令行可以很容易地在

Not used Workbench too much however it's easy enough to do from command line have a look at this (below phpMyAdmin instructions)

您要执行的命令是: mysql -u #username# -p #database# < #dump_file#

The command you're after is: mysql -u #username# -p #database# < #dump_file#

这篇关于使用MySQL WorkBench导入...错误ERROR 1046(3D000)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！