错误1049(42000):未知数据库"mydatabasename" [英] ERROR 1049 (42000): Unknown database 'mydatabasename'

问题描述

我正在尝试从.sql文件恢复数据库，我已经在phpmyadmin中创建了数据库，并且还在恢复到数据库的.sql文件中使用了create if not exist命令，并且两个数据库的名称都相同phpmyadmin和.sql文件，即"mydatabase".

I am trying to restore database from .sql file , i have created the database in phpmyadmin and also using the create if not exist command in the .sql file which i am restoring to the database and both names of database are same in phpmyadmin and .sql file which is"mydatabase".

这是我用来还原数据库的命令.

Here is the command which i am using to restore database.

mysql -uroot -pmypassword mydatabase<mydatabase.sql;

当我执行上述命令时，出现以下错误，我也已向用户授予对该数据库的所有权限.

When i execute the above command i am getting the following error, i have also given all the permission to the user upon this database.

ERROR 1049 (42000): Unknown database 'mydatabasename'

请帮助我如何解决此问题. 谢谢，

Please help me how can i solve this issue. Thanks,

推荐答案

如果转储文件包含:

CREATE DATABASE mydatabasename;
USE mydatabasename; 

您可以只在CLI中使用

You may just use in CLI:

mysql -uroot –pmypassword < mydatabase.sql

有效.

这篇关于错误1049(42000):未知数据库"mydatabasename"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！