Search code examples
databasemysqlredminebitnami

mysqldump unknown database bitnami_redmine

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

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 Enter password: ************ mysqldump: Got error: 1049: Unknown database 'bitnami_redmine' when selecting the database

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 |
+--------------------+

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

Thanks a lot,

moatze

Solution

  • 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.