大家好,我在用mysql导出数据时,遇到一个问题,请求高人解答。我的数据库和表都存在,但是导出时却报错Counld not find table ;
这是我的数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| rna |
| test |
+--------------------+
5 rows in set (0.00 sec)
这是数据库中的表
mysql> show tables;
+---------------+
| Tables_in_rna |
+---------------+
| class |
| organism |
| species |
| srna |
| users |
+---------------+
5 rows in set (0.00 sec)导出时出错C:\Documents and Settings\Administrator>mysqldump -uroot -proot rna srna>d:\my.s
ql;
mysqldump: Couldn't find table: "srna;"C:\Documents and Settings\Administrator>mysqldump -uroot -proot rna srna>d:\my.s
ql;
这是我的数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| rna |
| test |
+--------------------+
5 rows in set (0.00 sec)
这是数据库中的表
mysql> show tables;
+---------------+
| Tables_in_rna |
+---------------+
| class |
| organism |
| species |
| srna |
| users |
+---------------+
5 rows in set (0.00 sec)导出时出错C:\Documents and Settings\Administrator>mysqldump -uroot -proot rna srna>d:\my.s
ql;
mysqldump: Couldn't find table: "srna;"C:\Documents and Settings\Administrator>mysqldump -uroot -proot rna srna>d:\my.s
ql;
select * from srna limit 10;
select * from srna;
提示什么:
mysql -uroot -p123 -N -e "select * from srna;">123.txt
提示什么