ERROR 1146 (42S02): Table doesn't exist

2012-01-24 Thread Adarsh Sharma
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

Re: ERROR 1146 (42S02): Table doesn't exist

2012-01-24 Thread Johan De Meersman
- Original Message - From: Adarsh Sharma adarsh.sha...@orkash.com 1. Go to data dir : cd /hdd2-1/mysql_data/ 2. mv abc abc1 Whatever gave you the idea that it's a good plan to start messing with the files of a service whose inner workings you have no clue about? ERROR 1146