PDA

View Full Version : please help me to sort this out



itsvps
01-20-2007, 05:53 AM
for our project, my friend created some database and tables and also entered items to them.
we copied from his system, from data folder and then the folder having the created database's name.
then i copied them to my data folder in the mysqlsserver. but iam not able to access any data from it
please tell me how to access it.

mysql> use ceteee
Database changed
mysql> show tables;
+------------------+
| Tables_in_ceteee |
+------------------+
| facqua |
| faculty |
| stuadd |
| student |
| stufam |
+------------------+
5 rows in set (0.03 sec)

mysql> show columns from stuadd
-> \c
mysql> show columns from stuadd;
ERROR 1146 (42S02): Table 'ceteee.stuadd' doesn't exist