错误提示:mysqldump: Got error: 1049: Unknown database 'jpa;' when selecting the database
来源:互联网 发布:股市大数据数据宝app 编辑:程序博客网 时间:2024/05/12 12:27
在用命令做数据库备份过程在cmd命令框中输入C:/mysql/bin>mysqldump -uroot -p javashop es_tags es_settings>e:/tags.sql;
备份不了。
报错信息:mysqldump: Got error: 1049: Unknown database 'jpa;' when selecting the database ,识别不了jpa这个数据库。
但是我在:
mysql> show databases;
显示:
+---------------+
| Database |
+---------------+
| jpa |
+---------------+
mysql>use jpa;
显示:
Database changed
其原因很简单,只要记住一点。没进入mysql环境不算执行sql语句,所以不用在其后加入逗号(“;”)。
如果进入mysql环境mysql> ,则输入的语句属于sql语句了,在其最后一定要加上逗号(“;”)。
- 错误提示:mysqldump: Got error: 1049: Unknown database 'jpa;' when selecting the database
- 错误提示:mysqldump: Got error: 1049: Unknown database '***;' when selecting the database
- Mysql数据库备份的问题:mysqldump: Got error: 1049: Unknown database 'blog;' when selecting the database
- Mysql数据库备份的问题:mysqldump: Got error: 1049: Unknown database 'blog;' when selecting the database
- Mysql数据库备份mysqldump: Got error: 1049: Unknown database 'wisechalenge;' when selecting the database
- Mysql数据库备份的问题:mysqldump: Got error: 1049: Unknown database ‘blog;’ when selecting the database
- mysqldump: Got error: 1049: Unknown database 'base_name' when selecting the...linux mysql数据库备份的时候报错
- mysqldump: Got error: 1296: Got error 157 'Unknown error code' from NDBCLUSTER when using LOCK TABLE
- 备份错误mysqldump: Got error: 1016 when using LOCK TABLES
- MySQL的登陆错误:ERROR 1049 (42000): Unknown database 'yht'
- mysql ERROR 1049 (42000): Unknown database '******' ”错误处理办法
- ERROR 1049 (42000): Unknown database 'root'
- Mysqldump: Got error: 145错误
- Creating test database for alias 'postgres'... Got an error creating the test database: permission
- mysql -- mysqldump错误:Got error: 1044: Access denied for user ... when using LOCK TABLES
- Error while performing database login with the Mysql connector driver;Unknown database 'test'
- mysqldump got error:2002 及got error:1045错误解决方案
- Codeigniter中禁止A Database Error Occurred错误提示
- cocos2d
- semop SEM_UNDO标识
- maven-resources-plugin error using copy-resources goal: 'resources', 'outputDirectory' missing or in
- Android中Touch事件流向
- oracle 10g Data Guard Broker的一个Bug
- 错误提示:mysqldump: Got error: 1049: Unknown database 'jpa;' when selecting the database
- jquery datatable 参数
- IE浏览器内存泄露检测工具
- Android学习笔记
- 栅格数据空间分析之一从地图代数算术运算说起
- Asp.net 操作XML实现网站配置
- Hadoop运行class类出现Exception in thread "main" java.lang.NoClassDefFoundError:*
- Android学习笔记
- 数据段 代码段 堆 栈 BSS