----- 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 (42S02): Table 'abc1.job_queue' doesn't exist Fancy, isn't it? > I tried to roll back my procedure by mv abc1 abc but still problem > occurs. Yeps. That's the wonderful world of metadata caching for you. Restart your MySQL daemon and pray to whatever you believe in that your tables aren't *too* much corrupted. In the future, stay inside MySQL. Create a new database named to your liking, and repeat RENAME TABLE old-database.tablename TO new-database.tablename for every table in the database. Don't forget to update the relevant users' permissions, too. No, there is no RENAME DATABASE command for various reasons, some of which are explained in the quite excellent online documentation which, incidentally, would have told you that you were going to mess up your database. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
