mysqldump未知数据库bitnami_redmine [英] mysqldump unknown database bitnami_redmine

问题描述

我目前正试图将mysql数据库从Windows机器上的Bitnami Redmine栈迁移到Ubuntu。

I'm currently trying to migrate the mysql database from the Bitnami Redmine stack on a Windows machine to Ubuntu.

当我尝试mysqldump时，数据库发生以下情况：

When I try to mysqldump the database following happens:

C：\BitNami\redmine-2.3.1-1\mysql\bin> mysqldump -u root -p bitnami_redmine > backup_redmine.sql
输入密码：************
mysqldump：遇到错误：1049：选择数据库时未知的数据库'bitnami_redmine'

C:\BitNami\redmine-2.3.1-1\mysql\bin>mysqldump -u root -p bitnami_redmine > backup_redmine.sql Enter password: ************ mysqldump: Got error: 1049: Unknown database 'bitnami_redmine' when selecting the database

mysqlshow提供以下输出：

mysqlshow give following output:

C:\BitNami\redmine-2.3.1-1\mysql\bin>mysqlshow -u root -p
Enter password: ************
+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| mantis             |
| mysql              |
| performance_schema |
+--------------------+

有人可以告诉我为什么bitnami_redmine数据库不会显示在mysql数据库下？

Can someone tell me why bitnami_redmine database isn't shown under mysql databases?

非常感谢，

moatze

推荐答案

如果数据库确实存在于该服务器上，root用户没有权限查看它，但除非您特别限制root用户的权限，否则不太可能。
否则，像注释中提到的Kevin，该服务器上不存在数据库。

If the database really exists on that server, the root user does not have permissions to see it, but that is not very likely unless you have specifically limited the permissions of the root user. Otherwise, like Kevin mentioned in the comment, the database does not exist on that server.

这篇关于mysqldump未知数据库bitnami_redmine的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！