DB engines that have their own data dictionary (Innodb, etc) in addition to what is in the .frm could easily be messed up.
On Sat, Nov 21, 2009 at 10:38 AM, Robinson, Eric <eric.robin...@psmnv.com>wrote: > I used a simple procedure to rename my MySQL 4.1.22 database, which has > only My-ISAM tables: > > 1. Stopped MySQL > 2. Renamed the database directory from olddbname to newdbname > 3. Started mysql > > At this point, I grepped for 'olddbname' and found that many of the old > .MYI files still had references to 'olddbname'. So I... > > 4. Did mysqlcheck -o newdbname > > Then all the references to 'olddbname' were removed from the index > files. > > I then started our application and everything seems to be working fine > using the new database name. Yet I'm still worried because when I Google > it, I see people talking about lots of different ways to do a database > rename, and people are making it sound like a complicated, dangerous > procedure. > > Why would my simple approach not work? Should I be watching for > potential problems down the road because I did it this way? > > > -- > Eric Robinson > Director of Information Technology > Physician Select Management, LLC > 775.885.2211 x 111 > > > -- Rob Wultsch wult...@gmail.com
