Dear all,
Today I changed my database name from abc to abc1 by the below commands :-
1. Go to data dir : cd /hdd2-1/mysql_data/
2. mv abc abc1
But when I go to the mysql prompt & try to use the tables in abc
database , below error occurs:
ERROR 1146 (42S02): Table 'abc1.job_queue' doesn't exist
I also check the permissions in data dir they are :
2 -rw-rw---- 1 mysql mysql 9227 Mar 17 2010 job_queue.frm
I tried to roll back my procedure by mv abc1 abc but still problem occurs.
Thanks in Advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql