List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:January 24 2012 12:19pm
Subject:ERROR 1146 (42S02): Table doesn't exist
View as plain text  
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

ERROR 1146 (42S02): Table doesn't existAdarsh Sharma24 Jan
  • Re: ERROR 1146 (42S02): Table doesn't existJohan De Meersman24 Jan